Vlookup to retrieve an ID from table using text match
- by Federico Giust
I've got an excel spreadsheet where I would normally use a VLOOKUP.
In this case I need to find the ID of the record when comparing email addresses, so the email address is the unique id here.
For example on sheet 1
A B C D
Person Id | Family Name | First Name | Email
#N/A | Doe | John …