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