| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparing a number in a cell against multiple numbers in the same
Another one:
=IF(COUNT(FIND(","&A16&",",","&U15&",")),"Match"," No Match") -- Biff Microsoft Excel MVP "mpenkala" wrote in message ... Hey again gang, should be an easy one. In cell A16 I have the number 27 In cell U15 I have 23,35,4,16 (written just like this). What I'm looking for is in cell V15 to determine whether the number in A16 (27) is a match to any of the numbers in u15 (23,35,4,16) - this time it isn't. If it is, then I would like to get a "Match", if not "No Match" Thanks! Matt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing characters in one cell to multiple cells | Excel Worksheet Functions | |||
| Comparing multiple cell values | Excel Discussion (Misc queries) | |||
| comparing a value in a cell to see if it is higher than a number | Excel Worksheet Functions | |||
| INTRICATE PROBLEM- How to find multiple text,excluding "H", in a multiple range of cells, then replacing 0 with another number in another cell | Excel Worksheet Functions | |||
| Can you add multiple numbers in the same cell%3f | Excel Worksheet Functions | |||
Threaded Mode
