VLOOKUP #NOMATCH error linking to another Smartsheet

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. 

Best Answer

  • Ryan Sides
    Ryan Sides ✭✭✭✭✭✭
    Answer ✓

    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

    Smartsheet Tips and Tricks for Beginners and Advanced on LinkedIn and YouTube

    Come Say Hello!

Answers

  • Ryan Sides
    Ryan Sides ✭✭✭✭✭✭
    Answer ✓

    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

    Smartsheet Tips and Tricks for Beginners and Advanced on LinkedIn and YouTube

    Come Say Hello!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!