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!