I posted this question once but the answer I got returned #NA. So I'm asking
for help again....

I need to search one column of worksheet 3 and find where the text "car"
occurs in c4:c44, for whichever cell in column c contains the text "car" (if
it is in c34), I need it to return the value contained in column b (the value
I would be looking for in this example would be b34.

This information will be pulled from sheet 3 of a worksheet and posted in
sheet 1.