vlookup with multiable cell references?

[The _Magician]

is there a way to do a vlookup with more than one cell reference for example maybe I need to look up jon smith 'A2' and have a second cell reference may be Date in 'B2' and find the match in a range. I do it know but I concatenate to pieces of information to make a unique record.

 

[venkat1926]

use SUMPRODUCT
see help in excel and alo this url

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

 

[pgc01]

Hi

If you want to apply conditions to a search like vlookup and you are searching text or looking-up tables with numerical values where conditions may meet multiple times, use INDEX/MATCH.

Hope this helps
PGC

 

[The _Magician]

awesome thank you both for your help

LOOKS LIKE ANOTHER GREAT SITE TO SEE GREAT INFORMATION ON EXCEL!