Not sure it's even possible but would like to be able to accomplish this without the use of VBA or macros (end-user will not be able to maintain if I do). Within the same worksheet basically "query" a list of values in another tab to see if there are any matches.
Reason:
Specific text could occur in text string in one of three columns so thought the best possible solution would be to concatenate the three possibilities then have a column that looks for a MATCH in the other tab\named range with values. Problem is it's only getting 1st close match then quitting (but can't force exact match since the possibly words could occur anywhere in that concatenated string). I just need to know if at least one of the values occurs as an exact match and which value.
So in first tab I have
A B C
this is a real problem to try and solve
D
this is a real problem to try and solve
In next tab\named range these are the values
real
try
uber
difficult
I would like col-E to return an X or the index of the\a matching value and col-F to return matching value itself.
I have confidence that some Uber-Excel genius can help me out with this!

Reason:
Specific text could occur in text string in one of three columns so thought the best possible solution would be to concatenate the three possibilities then have a column that looks for a MATCH in the other tab\named range with values. Problem is it's only getting 1st close match then quitting (but can't force exact match since the possibly words could occur anywhere in that concatenated string). I just need to know if at least one of the values occurs as an exact match and which value.
So in first tab I have
A B C
this is a real problem to try and solve
D
this is a real problem to try and solve
In next tab\named range these are the values
real
try
uber
difficult
I would like col-E to return an X or the index of the\a matching value and col-F to return matching value itself.
I have confidence that some Uber-Excel genius can help me out with this!
