VLOOKUP not working in a specific sheet of destination

Adrià Termes
Adrià Termes ✭✭✭
edited 09/20/23 in Formulas and Functions

Hi all.

I am trying to do a simple VLOOKUP calling to a sheet as simple as the following one, wanting to get out of the Worker the Manager in the next column

Nonetheless, I am puzzled. When I open a new blank sheet and do the changes, the VLOOKUPS works perfectly, but in the following sheet, with exact same formula and trying both the "Created By" column and a dummy with the actual contact name, there appears as #NO MATCH. I tried many other things, but I cannot really know whta the issue is, as it works in another sheet.

Does anybody have any idea why is this the case, and if so, how can I solve it?

Thank you in advance!

Adrià Termes


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!