Excel 2007 : 2 workbooks, 1 common ref number, need to find other data...

Please help me! I have two large workbooks, both books have one ID number in common. Using the ID number from workbook A, I need to look up that ID number in workbook B, then retrieve a secondary reference number. I have used a Vlookup, but found it was finding the closest match, I need an exact match! It's driving me crazy, when I sound it out it seems simple, eg IF A1 (from workbook1) can be found in Column B (workbook 2) please give me answer from Column E (workbook 2). Not all the ID numbers from workbook 1 are found in workbook 2. Any ideas? Many thanks.

Hi

VLOOKUP gives an exact match as follows =VLOOKUP(A1,B1:C200,2,0)

Thanks for your response, I have tried the formula but keep getting #N/A

Hi

Try adding 'FALSE' to the end of your formula, that should return only exact matches.

=VLOOKUP(A1,B1:C200,2,FALSE)

Phil

Originally Posted by mill

Thanks for your response, I have tried the formula but keep getting #N/A

This means that there was no correspondence
Did you add the absolute addressing for the lookup range before pulling down?

=VLOOKUP(A1,$B$1:$C$200,2,0)