easy solution, just cant remember how to
 

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

--
foamcow
-----------------------------------------------------------------------
foamcows's Profile: http://www.excelforum.com/member.php...fo&userid=1853
View this thread: http://www.excelforum.com/showthread.php?threadid=49758

easy solution, just cant remember how to
 

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

easy solution, just cant remember how to
 

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

easy solution, just cant remember how to
 

perfect, thanks so much.


--
foamcows
------------------------------------------------------------------------
foamcows's Profile: http://www.excelforum.com/member.php...o&userid=18538
View this thread: http://www.excelforum.com/showthread...hreadid=497586