P
Pete
Am using this formula:
=IF(ISNA(MATCH($N$1:$N$8,$C$9:$G$9,0)),"Y","N")
to review columns C through G to determine if any of the columns contain a value found in the range $N$1:$N$8
It works fine, but what I'd like the formula to return is the actual value that was matched. (From there, I could do a lookup against the result, and pull in another value.)
TIA for any ideas.
Pete
=IF(ISNA(MATCH($N$1:$N$8,$C$9:$G$9,0)),"Y","N")
to review columns C through G to determine if any of the columns contain a value found in the range $N$1:$N$8
It works fine, but what I'd like the formula to return is the actual value that was matched. (From there, I could do a lookup against the result, and pull in another value.)
TIA for any ideas.
Pete