| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
integrating row number in a formula
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
integrating row number in a formula
works perfectly...thanks for the info!!
Jim Thomlinson wrote: I think you want indirect ="S_"& indirect("A" & row()) &"_"&TEXT(C3,"dd") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Integrating Networkdays() Into Formula | Excel Worksheet Functions | |||
| Integrating a work sheet into another | Excel Discussion (Misc queries) | |||
| Integrating variables in formulas in VB??? | Excel Programming | |||
| URGENT !!! Integrating Axes | Charts and Charting in Excel | |||
| Integrating Excel with Access | Excel Discussion (Misc queries) | |||
Linear Mode
