| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparing a number in a cell against multiple numbers in the same
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
comparing a number in a cell against multiple numbers in the same
Here's my first thought:
=IF(ISERROR(FIND(" " & A16 & " "," " & SUBSTITUTE(U15,","," , ") & " ")),"no match","match") I'm putting each number between a couple of space characters then looking for a match. That avoids the potential of matching a couple of digits (eg finding "23" as part of "423"). Then if the 'find' returns an error, then I've got 'no match'. "mpenkala" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
comparing a number in a cell against multiple numbers in the s
excellent, works like a charm.
Appriciate the help! Matt "bpeltzer" wrote: Here's my first thought: =IF(ISERROR(FIND(" " & A16 & " "," " & SUBSTITUTE(U15,","," , ") & " ")),"no match","match") I'm putting each number between a couple of space characters then looking for a match. That avoids the potential of matching a couple of digits (eg finding "23" as part of "423"). Then if the 'find' returns an error, then I've got 'no match'. "mpenkala" wrote: 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 |
|
#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 |
| Reply |
| 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 | |||
Hybrid Mode
