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