Values in a list

[dave8]

I have some values in a column, 30, 50, 80, 10, and so forth and they are not necessarily in consecutive order. Is there a way to search this column for particular values? In other words, I want to search this column to see if values 200, 90, and/or 50 exist in this column. Is there a way to do this? If I am going to use a vLookup, how to do this? Is there a lookup routine to search the column if it contains these values?

Your help is greatly appreciated. Thank you.

 

[shadow12345]

You could use =match

So if the values are in col B, and you have a "Value to find" in A1 and this formula in A2
=MATCH(A1,B:B,0)

 

[AlphaFrog]

This will return True\False if column B contains the value 50

=COUNTIF(B:B, 50)>0

 

[dave8]

I'm not sure I understand the Match function. How is this different from using a vLookup?

I want to seach the column, in this case column 'B', for any values containing, say, '200', '99' or '5', for example.

So, =MATCH(A1, B:B, 0) ? I have a list of values in Column B1..B10. I want to be able to search the values in Column B to see if any contain '200', '99' or '5'. What is in A1??

 

[shadow12345]

A1 is where you can type in the value you want to match... if it find a value it give you the row it appears on.

If you don't want to be able to change it, and always look for say 20 then its =match(20,B:B,0)