easy solution, just cant remember how to

[foamcows]

I have a list of 30 different vehicle stock numbers, these are known as special units. when I enter a stock number of a sold unit I would like another column to search the list of 30 stock numbers to see if it has a match and if it does display a 1 or a yes, or something. If there is no match then display a blank. I just cant for the life of me figure out how to get it to search the field. something like if a5=b6:b36 then yes, otherwise no. thanks for the help, sorry if it wasnt challenging.

[Jim Thomlinson]

Take a look at the countif function.
--
HTH...

Jim Thomlinson


"foamcows" wrote:

>
> I have a list of 30 different vehicle stock numbers, these are known as
> special units. when I enter a stock number of a sold unit I would like
> another column to search the list of 30 stock numbers to see if it has
> a match and if it does display a 1 or a yes, or something. If there is
> no match then display a blank. I just cant for the life of me figure
> out how to get it to search the field. something like if a5=b6:b36 then
> yes, otherwise no. thanks for the help, sorry if it wasnt challenging.
>
>
> --
> foamcows
> ------------------------------------------------------------------------
> foamcows's Profile: http://www.excelforum.com/member.php...o&userid=18538
> View this thread: http://www.excelforum.com/showthread...hreadid=497586
>
>

[Toppers]

Try:

A5 is stock number sought, B6:B36 is list of stock numbers

Place in required cell:

=IF(ISNA(MATCH(A5,$B$6:$B$36,0)),"","YES")

HTH
"foamcows" wrote:

>
> I have a list of 30 different vehicle stock numbers, these are known as
> special units. when I enter a stock number of a sold unit I would like
> another column to search the list of 30 stock numbers to see if it has
> a match and if it does display a 1 or a yes, or something. If there is
> no match then display a blank. I just cant for the life of me figure
> out how to get it to search the field. something like if a5=b6:b36 then
> yes, otherwise no. thanks for the help, sorry if it wasnt challenging.
>
>
> --
> foamcows
> ------------------------------------------------------------------------
> foamcows's Profile: http://www.excelforum.com/member.php...o&userid=18538
> View this thread: http://www.excelforum.com/showthread...hreadid=497586
>
>

[foamcows]

perfect, thanks so much.