VLOOKUP wild card matches

mindbender

New Member
Joined
Oct 30, 2015
Messages
13
Hi there,

I am stuck and maybe VLOOKUP is not the way to go at all but here is what I am trying to do.

I have a column where uses paste data ex: HP LaserJet 4014n Printer
I want to update this data with the Correct Product name from a different tab in the sheet. Table_Array 'Price List Jan 1 18'!1:1048576
I Choose Column index number as 1 because the value I want to return is in the first column
I choose True because I want am pretty sure the values won't match exactly

The value the VLOOKUP returns is: HP LaserJet 4000tn
What I was hoping it would return is another value: HP LaserJet P4014dn because the model is a 4014 not a 4000.

I assume this is happening because of alphabetical order of the table array.

Is there a way to make the VLOOKUP return a selection of results for the user to choose from or if I set it to FALSE have it show a drop down where the user could scroll to the correct model from the list.

Again maybe VLOOKUP is not the way to go here.

Any help would be appreciated. I am stuck.
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Forum statistics

Threads
1,223,893
Messages
6,175,240
Members
452,621
Latest member
Laura_PinksBTHFT

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
Back
Top