help need to match a string

[SMILE]

Hi everyone
Hope someone have a solution for me.
I have a table with product name and price in column a & b in sheet1
I have the formula in sheet2 where I input the product name in A1 an
it search the product and give me the price.
=VLOOKUP($A$1,Sheet1!$A$1:$B$1377,2,0).
It works ok.

Here my problem:
I have a product name called "HK-2859 plus" and I need this product t
be identified if I enter any portion of this product ("HK" or "2859" o
"plus"....).

appreciate your help

Thank

 

[Frank Kabel]

Hi
one way: Use the following array formula (entered with
CTRL+SHIFT+ENTER)
=INDEX('sheet1!'B1:B1377,MATCH(TRUE,FIND(A1,'sheet1'!A1:A1377)>0,0))

Frank

 

[Aladin Akyurek]

=VLOOKUP("*"&$A$1&"*",Sheet1!$A$1:$B$1377,2,0)

 

[SMILE]

Hi all
thank you for the help.
tom