integrating row number in a formula

Ok gurus,
Here's another one. I want to pull a value out of a certain column
based on the row that the formula is in. For example:

-The desired value is in A column (number value)
-The row() function will return the row that the formula is in
-Lets say row returns 13
-I would like to retreive the text value in A13 dynamically using row()
within the formula.....something like

="S_"&"5133"&"_"&TEXT(C3,"dd")

-The "5133" would be the text value of the number from A13 as determined
by row

Sorry if these are noob questions. I'm new to excel and still
learning my way around

-Dan

I think you want indirect

="S_"& indirect("A" & row()) &"_"&TEXT(C3,"dd")

--
HTH...

Jim Thomlinson


"Grymjack" wrote:

> Ok gurus,
> Here's another one. I want to pull a value out of a certain column
> based on the row that the formula is in. For example:
>
> -The desired value is in A column (number value)
> -The row() function will return the row that the formula is in
> -Lets say row returns 13
> -I would like to retreive the text value in A13 dynamically using row()
> within the formula.....something like
>
> ="S_"&"5133"&"_"&TEXT(C3,"dd")
>
> -The "5133" would be the text value of the number from A13 as determined
> by row
>
> Sorry if these are noob questions. I'm new to excel and still
> learning my way around
>
> -Dan
>

works perfectly...thanks for the info!!

Jim Thomlinson wrote:
> I think you want indirect
>
> ="S_"& indirect("A" & row()) &"_"&TEXT(C3,"dd")
>