Nest a Vlookup referencing another table in an IF statement

AOBB

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

Paul Newcome

Try using false in the last section of the VLOOKUP to indicate an exact match.

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