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 |
[email protected]
On Sheet 2
A B C D
Person Id | Family Name | First Name | Email
12345 | Doe | John |
[email protected]
Basically on sheet 1 I've got 800 records, on sheet 2 450. I know the 450 are in Sheet 1, so I need to find the ids of those, and put them on sheet 1 where I've got lots more data for each person.
What I've tried so far is a VLOOKUP, but I keep getting an error. I'd like to do it with some sort of formula and not using any copy paste and remove duplicates.
Any ideas?