software

Hello,

I need a function that looks at two conditions and returns a value.
For example, I need a to look at cell H3 wich is CAPONE and also look
at cell a13 which is 1/7/06 and return a value from a range name -
apps.

I tried mixing up vlookups and match with no results.

Thanks,--
jlg5454
------------------------------------------------------------------------
jlg5454's Profile: www.excelforum.com/member.php...oamp;userid=30201
View this thread: www.excelforum.com/showthread...hreadid=499808If(And(H3=quot;CAPONEquot;,A13 = Datevalue(quot;01/07/2006quot;)),VLookup(xxx,yyy,###,###),quot;quot;)
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.quot;jlg5454quot; wrote:

gt;
gt; Hello,
gt;
gt; I need a function that looks at two conditions and returns a value.
gt; For example, I need a to look at cell H3 wich is CAPONE and also look
gt; at cell a13 which is 1/7/06 and return a value from a range name -
gt; apps.
gt;
gt; I tried mixing up vlookups and match with no results.
gt;
gt; Thanks,
gt;
gt;
gt; --
gt; jlg5454
gt; ------------------------------------------------------------------------
gt; jlg5454's Profile: www.excelforum.com/member.php...oamp;userid=30201
gt; View this thread: www.excelforum.com/showthread...hreadid=499808
gt;
gt;


It gives me the first match to the date. I want the exact match from
the name range with the criteria. There are four columns in this
range. First column is date, second is h3, third is something and
fourth is the data I want to return. Basically I want to lookup data
based on columns 1 and 2 matching.

Thanks--
jlg5454
------------------------------------------------------------------------
jlg5454's Profile: www.excelforum.com/member.php...oamp;userid=30201
View this thread: www.excelforum.com/showthread...hreadid=499808In that case, you need a column to concatenate the 2 values so that vlookup
can find both at the same time.
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.quot;jlg5454quot; wrote:

gt;
gt; It gives me the first match to the date. I want the exact match from
gt; the name range with the criteria. There are four columns in this
gt; range. First column is date, second is h3, third is something and
gt; fourth is the data I want to return. Basically I want to lookup data
gt; based on columns 1 and 2 matching.
gt;
gt; Thanks
gt;
gt;
gt; --
gt; jlg5454
gt; ------------------------------------------------------------------------
gt; jlg5454's Profile: www.excelforum.com/member.php...oamp;userid=30201
gt; View this thread: www.excelforum.com/showthread...hreadid=499808
gt;
gt;

Assuming your lookup table has the following form:
A........B..............C
Date....Name....Value
1/7......Capone..18
etc

Then the following ARRAY formula will do:
=OFFSET($C$1, MAX(ROW(1:100)*--($A$2:$A$101=a13)*--($B$2:$B$101=H3)),
0)

This means that you must use the key combination Shift Ctrl Enter to
commit.

HTH
Kostis Vezerides