Vlookup partial match

[katiuuszka]

Hello!

I have been looking for answer to this problem and could not find anywhere already prepared answer. Would be grateful for help.

I have list of postions with long text (ex.

PACS008UR GENTFDT151111 XEM 1610040055 444AUD1610100000604 ) and I have an table of reference: PAC flower XEM tree AUD house <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> </tbody> I'm trying to construct the formula to find if in the large text there is any of the positions from my table to return the description of the second column. could you please help me with that? thank you <tbody> </tbody> <tbody> </tbody>

<tbody>
</tbody>

 

[FormR]

Hi, welcome to the board!

Something like this maybe:

Excel 2013
	A	B	C	D	E
2	PACS008UR GENTFDT151111	flower		PAC	flower
3	XEM 1610040055	tree		XEM	tree
4	444AUD1610100000604 )	house		AUD	house
5	PACS008UR GENTFDT151111	flower
6	1610PAC040055	flower
7	444AUD1610PAC10000XEM0604 )	house
Sheet1

Cell Formulas
Range	Formula
B2	=LOOKUP(9.99999999999999E+307,SEARCH($D$2:$D$4,A2),$E$2:$E$4)

 

[katiuuszka]

thank you it worked!!!