# Excel - VLOOKUP

I have text in Column A from rows 4 to 300 sorted alphabetically.   I have text in column B from rows 4 to 150 sorted alphabetically.   I need a formula in Column C that will look at the value in Column B and if it's found in Column A it says 'YES'.  If not then 'NO'.
###### Who is Participating?

Commented:
Try using this formula in C4 copied down

=IF(COUNTIF(A\$4:A\$300,B4),"YES","NO")

this doesn't rely on the data being sorted - works either way.....

regards, barry
0

Commented:
Use this formula, paste in C4 and copy down:

=IF(ISNA(MATCH(B4,\$A\$4:\$A\$300,0)),"NO","YES")

Dave
0

Commented:
Try:

``````=IF(ISERROR(MATCH(B4,\$A\$4:\$A\$300,0)),"NO","YES")
``````
0

Commented:
Pretty impressive - no answers when I started typing mine - accepted before I pressed submit - you can't hang around here
0

Commented:
This formula is for cell C4:
=IF(ISNA(MATCH(B4,A:A,0)),"No","Yes")

Copy C4 and select the range C5:C150, then paste.
0

Commented:
andrewssd3 - I noticed :)  I must have been a split second too slow, lol :)

Dave
0

Author Commented:
Crap.. I'm sorry fellas.  First one worked so I just accepted.  I'm sure there is many ways to skin this cat :)   I appreciate all the responses.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.