Multiple VLookup for two different sheets

Options
Marcela Hernandez
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!

Best Answer

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Answer ✓
    Options

    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! 🙂

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!