UDF for Returning Results from Cross table

Hello,

I'm looking for a UDF to check if a cell contains values that have a cross reference in a cross table.
I hope the example will make clear what I mean.

Here's the brute force method based entirely off the formatting of your example file.

Please Login or Register  to view this content.

Thanks for your help, but thats not what I was looking for.
The results should be shown in range H24:H27 not in the cross table.
The cross table is used to get to the results.

An user enters values in lets say B24.
along the entered values are to "codes" that have a crossreference in the table.
These 2 codes should be returned in H24 (seperated by a comma)

Like this?

Please Login or Register  to view this content.

This is coming really close.
It doesn't return the match "BHG,CDE" in the second example. (there can be more than one)

And how do I get this all in an UDF?

Can you tell me the reason why

BHGGFTHIS PLK.RRF/56 BGTCDE

Become PLK,BGT,BHG,CDE

In such pairing and order?

The user is not aware of the cross table and will use codes "at random".
The solution should check the string for all instances with a cross reference in the table

btw, the order isn't that important.
BHG,CDE,PLK,BGT is also ok

OK, then the pairing
BHGGFTHIS PLK.RRF/56 BGTCDE

I just don't understand this pairing.

Are the Xs in teh first table come in play for the pairing?

H24:

=CrossRef($B$3:$M$20,B24)

Filldown

Please Login or Register  to view this content.

Awesome!
Exactly what I was looking for.
Thank you Jindon!

You are welcome.

I just didn't know the meaning of "X"s in the first place....