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
Check out the Formula Handbook template!