CF to highlight all matching values in two tables if a cell in another table has any value

CF to highlight all matching values in two tables if a cell in another table has any value

Please, I need help with this.

This is a bit confusing to explain, so please forgive me if I make no sense or if the title for this post is off.

If a cell in table T1 has any value (anything – and x, y, a word, or a number, etc.), then highlight in table T3 the values found in table T2 in the corresponding entire row.

In other words, if cell F22 has a value (in this case an X, but it can be any value as long as is not empty), then the values in table T2, in the entire row 22 (numbers 1 and 2 in this example) need to be highlighted in table T3 (the number 1 and 2 will be highlighted in table T3).

NOTES:

1. The values to be matched in T2 and T3 are alphanumeric, but in this example I only used numbers to make it simple.
2. Only table T3 needs to have highlights for the matching values.
3. Table T2 values for the entire row (for example H21:P21) need to be considered when matching them with table T3 (R21:R29). In this example, only column “H” and “I” have values but there could be more values all the way to column P.
4. Table T2 values go from left to right (row) and the values in table T3 go from top to bottom (column) but I suppose they could also be repositioned from left to right (I think it makes no difference as long as the matched numbers get highlighted in the table T3 range).
5. Table T1 could have more than one cell with values, therefore, even if the numbers repeat they must be highlighted in table T3 (same color or different color, doesn’t matter).
6. If table T1 has no values, then nothing gets highlighted (obviously).

Please see attached file. I made a duplicate to the right to illustrate manually what is needed.

Tricky in Office 2010. I had a solution using a helper column but that relied on TEXTJOIN which you don't have so I had to rewrite it. In Q21, I wrote this formula:

Please Login or Register  to view this content.

Which I then copied down to Q53. I chose a white font to hide it. Then I highlighted R21:R29 and used this formula for conditional formatting:

Please Login or Register  to view this content.

I've included this in the attached file.

WBD