Vlookup / Index-Match? - Using partial text match if possible

markpalmer

New Member
Joined
Sep 24, 2013
Messages
27
I have a workbook with 2 worksheets. One is named "Query" - its a inventory query from pos system. The other is named "convert" - this is where i want to convert a customers description of an item to match up with my pos item description / sku and price. on my "convert" sheet - i will have an item description that is entered in A5, A6, and downward - in B5 - i want to return my sku # from "Query" and D5 from "Query". I know this can be accomplished from index, match but i am not good at it for one thing so i need help with that. The other issue is that the A column text may not always match up exactly with the "query" item description.

here is what my "Query" worksheet looks like - and it is "dynamic" and will grow as time goes on - this is pulled from our pos system
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[/TR]
[TR]
[TD]6/7/2011
[/TD]
[TD]MCKEEGR1
[/TD]
[TD]2710
[/TD]
[TD]1
[/TD]
[TD]56.99
[/TD]
[TD]
[/TD]
[TD]817344
[/TD]
[TD]Avanti Stn/Nick Entry Lever
[/TD]
[/TR]
[TR]
[TD]6/7/2011
[/TD]
[TD]MCKEEGR1
[/TD]
[TD]2710
[/TD]
[TD]1
[/TD]
[TD]31.49
[/TD]
[TD]
[/TD]
[TD]817184
[/TD]
[TD]Avanti Stn/Nick Pass Lever
[/TD]
[/TR]
[TR]
[TD]6/7/2011
[/TD]
[TD]MCKEEGR1
[/TD]
[TD]2710
[/TD]
[TD]1
[/TD]
[TD]32.89
[/TD]
[TD]
[/TD]
[TD]817221
[/TD]
[TD]Avanti Stn/Nick Priv Lever
[/TD]
[/TR]
[TR]
[TD]6/7/2011
[/TD]
[TD]MCKEEGR1
[/TD]
[TD]2710
[/TD]
[TD]1
[/TD]
[TD]84.99
[/TD]
[TD]
[/TD]
[TD]F58PLYSN
[/TD]
[TD]F58Plysn Ply Ext S/N Handleset
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


now below is the look of my "convert" sheet i want to use for my work area - again the length of this will vary as need items are needed
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD](text below - will be copied of manually entered)
[/TD]
[TD]SKU number
(pulled from "Convert")
[/TD]
[TD]just text a note column
[/TD]
[TD](price - pulled from "query"
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]Avanti Privacy
[/TD]
[TD]817221
[/TD]
[TD][/TD]
[TD]32.89
[/TD]
[/TR]
[TR]
[TD]Avanti Passage
[/TD]
[TD]817184
[/TD]
[TD][/TD]
[TD]31.49
[/TD]
[/TR]
[TR]
[TD]Handleset
[/TD]
[TD]F58PLYSN[/TD]
[TD][/TD]
[TD]84.99[/TD]
[/TR]
</tbody>[/TABLE]

if there is a way to match from a partial description as above that would be ideal - if worse comes to worse - i can change the description manually to match the query descriptions.

Any help is greatly appreciated....if more info would help i can try to finll in the blanks or clarify.
 

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