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

[markpalmer]

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

A	B	C	D	E	F	G	H
6/7/2011	MCKEEGR1	2710	1	56.99		817344	Avanti Stn/Nick Entry Lever
6/7/2011	MCKEEGR1	2710	1	31.49		817184	Avanti Stn/Nick Pass Lever
6/7/2011	MCKEEGR1	2710	1	32.89		817221	Avanti Stn/Nick Priv Lever
6/7/2011	MCKEEGR1	2710	1	84.99		F58PLYSN	F58Plysn Ply Ext S/N Handleset

<tbody>
</tbody>

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

(text below - will be copied of manually entered)	SKU number (pulled from "Convert")	just text a note column	(price - pulled from "query"
A	B	C	D
Avanti Privacy	817221		32.89
Avanti Passage	817184		31.49
Handleset	F58PLYSN		84.99

<tbody>
</tbody>

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.