View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mpenkala mpenkala is offline
external usenet poster
 
Posts: 90
Default 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