Some Vlookups returning #NoMatch, others are fine

ArthurC
ArthurC ✭✭✭✭
edited 12/09/19 in Smartsheet Basics

I have a training tracker with all the staff, their managers, locations and whether or not they have completed training.

I have multiple vlookups in columns manager, location, role, status and classification. The vlookups are referencing an HR file that we have that has all the raw information.

As you can see below, many of the vlookups are retuning #No Matches, where others are working. I have confirmed that employee 31671 is in fact in my other sheet, but I believe it’s Smartsheet not being able to find or too slow to return the values? I say this because this spreadsheet was working fine this morning with the same formulas. I’ve also locked those columns so nobody should have been able to alter the formulas.

Here's what i have:

=VLOOKUP([Employee ID]7, {HR Data Master WIP Range 1}, 6, false)

the 2nd screenshot is the confirmation that the entry is in HR Data Master. 

SS help.png

SS help1.png

Comments

  • Alejandra
    Alejandra Employee

    Hi ArthurC,

    I'd suggest double clicking in the cell containing the search value to ensure there isn't an underlying issue —like a leading apostrophe (leading apostrophes are sometimes present when a sheet is imported from Excel).

    I also partnered with the Support team to refresh the inbound and outbound links on both of your sheets. If you're still running into issues after trying the above, reach out to our Support team and they can troubleshoot further with you.