Is value a2 in B:b?

[sgnirtswob]

Hi,

I am up against the clock, and I need to know how to display in a cell "Yes" or "No" based on a value being (or not) in a column.

I have column A with values, and I want column C to show Yes/No based on if value x from say A2 exists as a whole matched valued in B2:b3000 and set c2="Yes" if it is, and no if it isn't.

I have tried to work this out my self, but being under pressure it's not making much sense, and I could do with a hand.

Im sure the answer must have been presented here, so even if some one can direct me to a post that would be good.

Many thanks in advance

[NBVC]

=Isnumber(Match(A2,$B$2:$B$3000,0)) will return TRUE if Match found, FALSE if not... copy it down the column...

[deemo]

Perhaps you can check whether the value you are looking for exists in the range, and if so display yes? So something like

=IF(COUNTIF(B2:B3000,"x")>0,"yes","no")

[sgnirtswob]

Many thanks, I was getting confused by various search results and the different ways you can do lookups in excel. I had tried a few permutations of those commands, but never got them to work.

It seems as though the following does what I need.
=IF(COUNTIF(B377:B3375,A377)>0,"yes","no")

Thanks for the quick responses.

[deemo]

Cool, don't forget to mark your post as [SOLVED] if it is...