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