If interval contains a value return corresponding-CodePudding

I have two tables

First:

ID  Text
AA  Example 1
BB  Example 2
CC  Example 3

Second:

ID       Text
132CC32  
112AA52  
142BB42

I need that in the second table, if the column "ID" (of the second) contains the value of "ID" of the first, return the corresponding text, like this:

ID       Text
132CC32  Example 3
112AA52  Example 1
142BB42  Example 2

The first table is small, it contains few values, but the second one can have thousands.

CodePudding user response：

Try this formula as shown in image below,

• Formula used in cell B7

=LOOKUP(9^9,SEARCH($A$2:$A$4,A7),$B$2:$B$4)