Multiple VLookup for two different sheets

Marcela Hernandez

Hola, hola!

Is it possible to perform a vlookup to search two two different sheets?

Here is my scenario: I need to check for duplicate addresses using a formula in my base sheet. The Address Sheet that holds the addresses has maxed out. So I created another version and now have Address Sheet1, which is new and blank and Address Sheet2 which holds all the original addresses.

I need to perform a vlookup to search Address Sheet 1 and Address Sheet 2.

Original formula: =IFERROR(IF(VLOOKUP([Service Address]@row, {AddressSheet1}, 1, false) <> "", "Found", "Not Found"), "Not Found")

My attempt to merge returned a syntax error:

=IFERROR(IF(VLOOKUP([Service Address]@row, {AddressSheet1}, 1, false) <> "", "Found", "Not Found"), VLOOKUP([Service Address]@row, {AddressSheet2}, 1, false) <>"", "Found", "Not Found"), "Not Found")

Muchas gracias!

Nick Korna

Hi @Marcela Hernandez,

Something along these lines:

=IFERROR(IFERROR(IF(VLOOKUP([Service Address]@row, {AddressSheet1}, 1, false) <> "", "Found"),IF(VLOOKUP([Service Address]@row, {AddressSheet2}, 1, false) <>"", "Found", "Not Found")),"Not Found")

Hopefully this helps, any problems/questions then just post! 🙂

Nick Korna

Hi @Marcela Hernandez,

Something along these lines:

=IFERROR(IFERROR(IF(VLOOKUP([Service Address]@row, {AddressSheet1}, 1, false) <> "", "Found"),IF(VLOOKUP([Service Address]@row, {AddressSheet2}, 1, false) <>"", "Found", "Not Found")),"Not Found")

Hopefully this helps, any problems/questions then just post! 🙂

Marcela Hernandez

Awesome! Thank you @Nick Korna! This worked perfect. 🤩🤩

Wishing you a wonderful day!