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 | jd@email.com
```

On Sheet 2

```
A B C D
Person Id | Family Name | First Name | Email
12345 | Doe | John | jd@email.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.

Any ideas?