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.
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.