Using a Flag column to identify associates that are on another sheet.

MyShell222

Hi,

I'd like to create a formula to vlookup a cell value from a separate smarsheet and if that associate is on that sheet, instead of pulling back #NO MATCH, and the cell value if it is on the other sheet, I'd like for it to flag an associate if they are on the list. So I'd like that column in my main sheet to be a flag or checkbox column and only if they are on the separate list, it will flag or check the box.

Any help is appreciated😀

Brent Wilson

@MyShell222

A quick one might be to flag those that do not exist on the sheet rather than flagging those that do

Have a look at the IFERROR and ISERROR Functions

something like =IFERROR(Your Vlookup Statement, TRUE)

would put a flag or check a box in a checkbox column if it did not exist

I think below would put a Flag where your vlookup worked

=IF(ISERROR(YourVlookup), False, True)