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: http://www.excelforum.com/member.php...o&userid=30201
View this thread: http://www.excelforum.com/showthread...hreadid=499808