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.
Ty
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)