VLOOKUP part of a text string.

[jonwhite]

Hi all,

Is there any way I can Vlookup for just part of a text stiring in a cell.
I am trying to vlook if a part number contains the letters “HFR” if it does I want
It to refer to the comment I have made in the second column of my vlook table against HFR.

Thanks in advance for all your help.

Cheers

Jon

 

[jonwhite]

Thats worked a treat!!!!


Thanks for all your help, really appreciate it

Have a good weekend

Cheers

Jon

 

[Airfix9]

You too - glad to be of (slow) service.

 

[manujuneja333]

Hi Jon,

Modify this:

 =VLOOKUP("*"&A2&"*",Sheet1!A:B,2,FALSE)

The asterisks either side mean that the text string appears anywhere in the table.

Thanks bigtime! your modification helped me a lot :D