Look ups

Hi Bernadette

Unfortunately, when using a VLOOKUP, the data you’re searching for has to be in the first column of your database and the columns you‘re searching have to be to the right of your search column.

The data also has to be an exact match (no excess spaces or commas or misspellings).

Looking at your file, I assume you’re trying to see if the person listed in row 2 has used the same surname on their passport for registration?

I would probably use an IF statement to check this rather than a VLOOKUP as VLOOKUP would mostly be used for finding data from another database rather than checking for matches

I have sent this back via email as well

Let me know if this helps

Kind regards
Wendy