Match a cell to something in a column and return a YES

G

Guest

I have two columns -
Column A is a list of company names for folks who took training
Column B is a list of preferred companies

I want to find out if the companies in column A are on the Preferred list.

All I can think of is If the company name in column A is found in Column B -
then say Yes.

I don't even care about the no's!

Can you help?
 
B

Bob Phillips

=IF(ISNUMBER(MATCH(A2,B:B,0)),"Yes","")

In C2 and copy down

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy corresponding cell in Column B if cell in A contains certain text? 1
Partial Text Match then enter desired result into appropriate colu 1
With F1 value, look at A, if match or partial match return B 5
Sum values from a vlookup 2
Are contents of at least one cell in a group a substring of a dif 3
Returning a value from the cell next to my match 2
Match value return a text 6
DSUM Partial Match 3

Top