intergrating row number into a formula

G

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
 
P

Pete_UK

Try this then, Dan:

="S_"&INDIRECT("A"&ROW())&"_"&TEXT(C3,"dd")

If the formula is in a cell on row 13, then it will incorporate the
contents of A13 within "S_" and "_whatever".

If you intend to copy the formula down the column, then you may need to
make C3 into absolute, i.e. C$3.

Hope this helps.

Pete
 
G

Grymjack

C3 was a date field that is being used to append a day code on the back
of the string. This is a cell name reference that it is pulling off of
another page. Your suggestion works perfectly...thanks!!

-Dan
 
Top