VLOOKUP #NOMATCH error linking to another Smartsheet

CJohnes

I get an #NOMATCH on what I believe should be a very simple lookup. I haven't found a previous discussion that solves my particular problem. My formula is: =VLOOKUP("Park", {Parks Master List Range 1}, 10, false). When I set the sheet reference to that range, I did so by simply selecting the columns in the reference sheet and it automagically created the range and inserted it into my formula. To create the sheet, I exported the existing sheet with the primary key ("Park" name) and then used that to upload into my new sheet to make sure my primary matched exactly. 

Ryan Sides

Hi there, so in your formula, it's looking for the exact word "Park", not your actual park names.

If your park names are listed in a column called "Park Names" you need to reference that in your formula like:

=VLOOKUP([Park Names]@row, {Parks Master List Range 1}, 10, false

Does that help?

Ryan Sides

Hi there, so in your formula, it's looking for the exact word "Park", not your actual park names.

If your park names are listed in a column called "Park Names" you need to reference that in your formula like:

=VLOOKUP([Park Names]@row, {Parks Master List Range 1}, 10, false

Does that help?