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.