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!
