One Last Formula Question
I have a spreadsheet with two tabs roster and users, both have a bunch of tabs.
in roster column F is email and column G is exist
in users column B is email
in roster if email is a hit anywhere in column B of users I want column G is roster to say OK otherwise it should say MISSING