FIND function?

[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.

[Biff]

Hi!

Try this:

A1 = d1

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

Biff

"Sonya" <Sonya@discussions.microsoft.com> wrote in message
news:673D126B-09F4-4044-9807-11EAA6CCA976@microsoft.com...
>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.

[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

[Peo Sjoblom]

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

--
Regards,

Peo Sjoblom

(No private emails please)


"Sonya" <Sonya@discussions.microsoft.com> wrote in message
news:CEB8CA96-5CBA-43AF-A951-5F02A734997C@microsoft.com...
>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
>