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
|