I am needing help with a Vlookup if it is possible.

I have a spreadsheet with names, First Name in Column A, Surname in Column B, and Column C as ID Number. The only 2 fields that are filled out as A&B(their names).

I run a report which opens another spreadsheet which shows their name and the ID Number, now instead of manually typing the ID from one spreadsheet to another i was hoping i could use a vlookup(or something) to find the first name and surname on the report and it then add their ID to my spreadsheet

I think i have made the above understandable, if it is not possible to use vlookup, then can you suggest something. Im not an expert with excel so i may need a hand



Thanks

Hi could you please post a sample sheet ( no pics pse) ? Thx

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

When using multiple criteria, I usually fall back on Sumproduct. See attached.

Attached Files

teza2k06.xlsx (8.7 KB, 15 views)