Search for a match

[VBisgreat]

Hi All,

I have data in col A and col B. For each value in each cell in col B, I want to search in col A to see if there is a match. If there is a match then in associated col C put “Yes” otherwise put “NO”. Repeat the same step for all other values in col B.

Thanks All,

VBisgreat

[jeffreybrown]

How about in column C...

=IF(MATCH(B1,$A$1:$A$100,0),"Yes","No")

You could also name the range in column A which would look like.

=IF(MATCH(B1,names,0),"Yes","No")

The named range is equal to names

[MarvinP]

Hey VBisGreat,

No need for Visual Basic on this one. Try a countif function and see the attached for your answer.

What version of Excel are you using? Your profile says 2003. I'd assume you have the latest if you are digging into VBA. I believe the Help files are a lot better in 2010 Excel for VBA, which might help you learn more.

[VBisgreat]

Thanks all
VBisgreat!