Hi!

Try this:

A1 = d1

=INDEX(Sheet3!A4:A60,MATCH(A1,Sheet3!B4:B60,0))

Biff

"Sonya" wrote in message
...
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.