help need to match a string

S

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
 
F

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
 
Top