Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Am I missing some easy solution to my problem? | Excel Worksheet Functions | |||
Easy to do but cannot remember how! | Excel Worksheet Functions | |||
Anyone got an easy solution | Excel Discussion (Misc queries) | |||
Easy Sumproduct or Sumif - but I can't remember how ..lol ! | Excel Worksheet Functions | |||
I know this is easy but I don't remember how. | Excel Discussion (Misc queries) |