I don't think it was unclear, put car in A1

--
Regards,

Peo Sjoblom

(No private emails please)


"Sonya" wrote in message
...
I think I might have been unclear. I think the reference of "d1" might have
led you to think it was a cell.

column a column b
Sara car


Let me restate it for clarification - where the text car occurs in b4:b60,
I
need it to return the corresponding cloumn text which in this example
would
be Sara. this information will be pulled from sheet 3 of a worksheet and
posted in sheet 1.
I hope this is more clear. Thanks for your help