Excel lookup help

cdcsolutions

Board Regular
Joined
Nov 22, 2011
Messages
55
Is there anyway a person can use the Vlookup to lookup a list by using partial information. Eg. In Cell B1 enter 8c-26-062-08 and it will find the info from Column C from a list that contains Eg. Bertsei 199/08c-26-062-08s4/02. By typing in column "B1" 8c-26-062-08, I want A1 to list "Bertsei 199/08c-26-02-08s4/02 which comes from Column C of a different sheet. My problem is that I want to type in only parts of the full description to result in the full description auto filling.

Help please if this is possible to do. I'm thinking of using Match? Thanks!
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

FormR

MrExcel MVP
Joined
Aug 18, 2011
Messages
6,631
Office Version
  1. 365
Platform
  1. Windows
Try, for example:

=VLOOKUP("*"&B1&"*",Sheet2!C1:C1000,1,0)
 

cdcsolutions

Board Regular
Joined
Nov 22, 2011
Messages
55
Thank-you so much! I am very close to resolving this issue. It works for one entry so I need to add within the formula the lookup for a variety of info in column B. For example I will have a different number 9B-25-062-09 in b2 and I need it to find that number within Column C. I will have hundreds of numbers looking throughout Column C for the numbers within a variety of info such as Bertsei 199/08c-26-062-08s4/02 . Eg Bersei 200/09c-25/062, Western 198/10b/5/062

Therefore a lookup in hundreds of cells in column but also typing in column B a variety of numbers. Thanks! I know the formula is close.
 

FormR

MrExcel MVP
Joined
Aug 18, 2011
Messages
6,631
Office Version
  1. 365
Platform
  1. Windows
Like this?

In A1 and copy down.
=VLOOKUP("*"&B1&"*",Sheet2!$C$1:$C$1000,1,0)

Change the 1000 to the known maximum number of rows in the other sheet.

Or A1 and copy down if the max rows is not known:
=VLOOKUP("*"&B1&"*",Sheet2!$C:$C,1,0)
 

cdcsolutions

Board Regular
Joined
Nov 22, 2011
Messages
55

ADVERTISEMENT

Like this?

In A1 and copy down.
=VLOOKUP("*"&B1&"*",Sheet2!$C$1:$C$1000,1,0)

Change the 1000 to the known maximum number of rows in the other sheet.

Or A1 and copy down if the max rows is not known:
=VLOOKUP("*"&B1&"*",Sheet2!$C:$C,1,0)

This works perfectly! Thankyou!
 

FormR

MrExcel MVP
Joined
Aug 18, 2011
Messages
6,631
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

If Column B is empty, I want the cell to be blank

Hi, try:

=IF(B1="","",VLOOKUP("*"&B1&"*",Sheet2!$C$1:$C$1000,1,0))
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,151,960
Messages
5,767,336
Members
425,404
Latest member
Bairkus

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