Vlookup or similar?

Posted by Ben on December 14, 2000 12:55 PM

Could anyone please tell me a formula that will search for the exact contents of cell A on sheet 1 and find it in column 1 on sheet 2 and display what is in cell G on sheet 2 and in cell B in sheet 1.

Thanks

Posted by Brice Gaertig on December 14, 2000 3:01 PM

Hi,
you want to use a INDEX(MATCH combination
i.e.
=INDEX('returned value location',MATCH('value location you want matched','lookup location for match',0))
the zero at the end specifies an exact match
for example
=INDEX(sheet2!g:g,MATCH(sheet1!a:a,sheet2!B:B,0)))