integrating row number in a formula

[Grymjack]

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

 

[Guest]

I think you want indirect

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

 

[Grymjack]

works perfectly...thanks for the info!!