Nest a Vlookup referencing another table in an IF statement

Options

Good Morning,


I have been rooting around the forums for a couple of days now trying solution after solution based on what I have ready on here for my issue.

Below is the formula I am currently using. comes back with #NO MATCH even though I know the lookup value is within the referred range.

=IF([Delivery / Pick Up]@row = "Pick-Up", 0, VLOOKUP([Driver Request #]@row, {BETA - Load List Tracker Range 2}, 10))


Any help is appreciated -- Thank you

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!