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: 236
  • Last Modified:

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'.
0
elwayisgod
Asked:
elwayisgod
1 Solution
 
barry houdiniCommented:
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
 
dlmilleCommented:
Use this formula, paste in C4 and copy down:

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

Dave
0
 
andrewssd3Commented:
Try:

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

Open in new window

0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
andrewssd3Commented:
Pretty impressive - no answers when I started typing mine - accepted before I pressed submit - you can't hang around here
0
 
SANTABABYCommented:
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
 
dlmilleCommented:
andrewssd3 - I noticed :)  I must have been a split second too slow, lol :)

Dave
0
 
elwayisgodAuthor 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

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

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