Hi
you may try the following array formula (entered with
cTRL+SHIFT+eNTER):
INDEX('sheet1'!B1:B100,MATCH("BBB",SUBSTITUTE('she et1'!A1:A100,"*",""),
0))

--
Regards
Frank Kabel
Frankfurt, Germany

"Alex" schrieb im Newsbeitrag
...
I have one spreadsheet with a column of products and another
spreadsheed with
the same products and prices.
I need to make links from the first sheet to the second one with the
prices
to reflect them in the first sheet.
The list of products is sorted differently. This is why I'm going to
use
VLOOKUP.

But, the problem is that in the first spreadsheet some products
marked with
*, which make them slightly different from those, which should be
find in
the second spreadsheet. As an example, BBB and *BBB.
How VLOOKUP could avoid this * to find the same product but without
this sign.

Thanks