Searching AlphaNumeric in Description Table to rtn a stock code.. HELP

1st Post, I have been trying for hours to crack this and cant figure it out!

I have a Problem...

I need to search for a Cell in a seperate worksheet looking in a long description field. Matching only part of the text string in the search range. If search target found to then return a Partcode from adjacent cell.

i.e.

Q60001A is value in C66

HP Color Laserjet 1600 2600 2605 Cyan Toner Q6001A is one Cell in range B2:B6000

I want to find this Cell and then show the adjacent value from column C.

I wont bore you with my numerous attempts but I can not get this figured out.. Anyone put me out of my misery? I have searched the forumns but any answers I find I can not apply to this problem and get a result..

Thanks for the suggestion, I am hoping to figure out a formulae solution as we often get lists of parts from suppliers with Mnf codes in but no reference to our internal SKU I want to develop a template that will allow us to drop the supplier data in and it to return a populated list of our sku/description/stock holding etc etc.

I will keep my fingers crossed for a genius/godsend reply..

I would not expect/Need more than 1 return per query

Sample attached. Need to populate SKU's Column C in Sample Supplier Data by searching for B2 in Inventory data Column A but need to find partial matches and return B2 number.

Ron,

Thank you. Thats the answer I was looking for.. simple when you know how I was doing my nut trying to figure out Wildcard Vlookup! Your a star.