Referencing another sheet using vlookup

omar1 · 08/03/18

Today's my first day using Smartsheet; I referenced another sheet for columns that I needed. Now rows that are not found in my specified range are auto populated with "#NO MATCH." I need guidance for making the "no match" blank. I tried an if statement but still having the same issue.

J. Craig Williams · 08/03/18

#NO MATCH is actually an error returned.

You can "catch it" using IFERROR()

=IFERROR(MATCH(thing-to-search-for, range-to-search, 0), "")

will return a blank.

Craig

Referencing another sheet using vlookup

Comments

Categories