asked on
Lookup formula
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
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
Microsoft Excel
Last Comment
5teveo
ASKER
does not seem to want to allow me to add that formula keeps saying error
roster
F=email
G=exist (this is the column we want to say OK or MISSING
users
B=email
roster
F=email
G=exist (this is the column we want to say OK or MISSING
users
B=email
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Try this...
I used vlookup command assuming email address lookup can occur anywhere 'User'
Ah... Count works also... i did not read other solution fully
EE-20130104-Lookup.xlsx
I used vlookup command assuming email address lookup can occur anywhere 'User'
Ah... Count works also... i did not read other solution fully
EE-20130104-Lookup.xlsx
=IF(COUNTIF(users!B:B,F2),
regards, barry