partial vlook issue

slash32487

Board Regular
Joined
Jun 8, 2009
Messages
54
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).
2vajt5l.jpg

wck286.jpg
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

AlexandraT

Board Regular
Joined
Mar 23, 2015
Messages
144
It's not clear where you want to retrieve the values from. can you show column A which you use in the vlookup?
 

mick0005

Active Member
Joined
Feb 21, 2011
Messages
406
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.

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

Excel 2010
BCDEF
1Search ForResultLookup Table
2987Part2AAA1234567-BBPart1
3345Part1BBB987654321-CCPart2
4DDPart3CCC456654-DDPart3

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

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

<thead>
</thead><tbody>
</tbody>

<tbody>
</tbody>
 

slash32487

Board Regular
Joined
Jun 8, 2009
Messages
54
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,469
Messages
5,596,316
Members
414,053
Latest member
Dual Showman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top