FIND function?

S

Sonya

I need to search a column for text and return the value from the column
beside it.

so... where "d1" occurs in b4:b60, I need it to return the value in cloumn
a. this information will be pulled from sheet 3 of a worksheet and posted in
sheet 1.

so if in sheet 3 - "d1" appears in b16 then I need it to return the value in
a16 in sheet 1 in a designated cell. This is all text formatting.
 
S

Sonya

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
 
P

Peo Sjoblom

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

--
Regards,

Peo Sjoblom

(No private emails please)
 
Top