iferror(vlookup issue
Paula Cosentino
✭✭✭✭✭
Hello, I'm trying to create a formula using Vlookup but if it doesn't find a match in one smartsheet, I want it to look in another smartsheet. I can't put everything into one smartsheet because there are two many rows. I am getting an error on the following formula:
=IFERROR(VLOOKUP([Individual NPI Number]@row, {ind npi 0 to 13000 rows Range 2}, 2, false, IFERROR(VLOOKUP([Individual NPI Number]@row, {ind npi 13001 plus rows Range 4}, 2, false))))
Any help would be greatly appreciated. Thank you.
Answers

It looks like you didn't close the parenthesis on your first VLOOKUP statement is all :)

thank you Mike. Do you mean a paren is missing inside the formula? I have 4 at the end?
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 63 Global Discussions
 68 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!