Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

Which formula works for this situation?

I have a list of names in Column G, and I need to know if those names also appear in column O, and I would like the results to be displayed in Column H.

Which formula should I use and how do I input that data?
thank you.
0
binaryman101
Asked:
binaryman101
1 Solution
 
barry houdiniCommented:
Try using this formula in H2 copied down

=COUNTIF(O:O,G2)>0

You get TRUE or FALSE results

regards, barry
0
 
binaryman101Author Commented:
perfect thank you!
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.

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