If Statement with nested VLOOKUP formula
Hi! I would like to return a value from another SmartSheet if one column in that same SmartSheet has a "Y". I have the current formula below, but it's returning a #NO MATCH error... any thoughts?
In summary: return value in column A of SmartSheet Y to SmartSheet X if coulumb B in SmartSheet Y = Yes.
=IF(VLOOKUP(Customer@row, {A3DPV Master Printing Status Range 4}, 5, false) = "Y", VLOOKUP(Customer@row, {A3DPV Master Printing Status Range 4}, 2, false), false)
Thank you!
Thu
Best Answers

Hi Thu,
The column count, is this correct and looking in the correct column numbers.
You've typed false for the false statement, try putting that in double quotes  "False"
Thanks Graham

Hi @Thu Nghiem, daft question, but I'd need to ask, the range you've set up, I assume does include the columns you need, and are there some "Y"s in the column your looking for?
Do you have multiple references of the same customer?
Answers

Hi Thu,
The column count, is this correct and looking in the correct column numbers.
You've typed false for the false statement, try putting that in double quotes  "False"
Thanks Graham

Hi @graham18628!
Yes, I believe the column counts are correct. I did go ahead and put False in quotations, but it still gave me the #NO MATCH error.
Revised formula: =IF(VLOOKUP(Customer@row, {A3DPV Master Printing Status Range 4}, 5, false) = "Y", VLOOKUP(Customer@row, {A3DPV Master Printing Status Range 4}, 2, false), "false")
Thank you!
Thu

Hi @Thu Nghiem, daft question, but I'd need to ask, the range you've set up, I assume does include the columns you need, and are there some "Y"s in the column your looking for?
Do you have multiple references of the same customer?

Morning, @graham18628!
I came back to it today and the formula seems to be working! YAY! Thank you for all of your help. I didn't alter anything from the formula I C&P'ed above, I guess SmartSheets just needed some time to refresh.
Thank you again for all of your help and happy holidays!!
Thu

@Thu Nghiem no a problem. Glad it's working for you.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 454 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!