partial vlook issue

[slash32487]

i have these 2 excels. i need to grab the inventory from one and put it on the other. the 2 fields are not exactly the same but they have partial info. i tried doing this example but it didnt work =VLOOKUP("*"&B1&"*",A1:A10,1,FALSE).

 

[AlexandraT]

It's not clear where you want to retrieve the values from. can you show column A which you use in the vlookup?

 

[mick0005]

As Alexandra said, it is not clear where you are trying to retrieve your values from, but I mocked this up and your formula should be working. Note I changed my cell references just for my mockup.

=IF(ISBLANK(B2),"",VLOOKUP("*"&B2&"*",$E$2:$F$4,2,FALSE))

Excel 2010

	B	C	D	E	F
1	Search For	Result		Lookup Table
2	987	Part2		AAA1234567-BB	Part1
3	345	Part1		BBB987654321-CC	Part2
4	DD	Part3		CCC456654-DD	Part3

<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula C2 =IF(ISBLANK(B2),"",VLOOKUP("*"&B2&"*",$E$2:$F$4,2,FALSE)) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[slash32487]

worked! i was able to get different info that would help me find the info a bit easier but still needed that formula for it to find what i needed