Multiple VLookup for two different sheets
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
-
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
-
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! 🙂
-
Awesome! Thank you @Nick Korna! This worked perfect. 🤩🤩
Wishing you a wonderful day!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!