Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 308
  • Last Modified:

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
0
Matt Pinkston
Asked:
Matt Pinkston
  • 2
1 Solution
 
barry houdiniCommented:
Try this formula in roster worksheet G2 copied down

=IF(COUNTIF(users!B:B,F2),"OK","missing")

regards, barry
0
 
Matt PinkstonAuthor Commented:
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
0
 
barry houdiniCommented:
See attached example - note: depending on your region the formula might require semi-colon separators instead of commas, i.e.

=IF(COUNTIF(users!B:B;F2);"OK";"missing")

regards, barry
email-example.xls
0
 
5teveoCommented:
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
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now