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 | firstname.lastname@example.org
On Sheet 2
A B C D Person Id | Family Name | First Name | Email 12345 | Doe | John | email@example.com
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.