Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i use the data in one cell as the row number of another cel
hello
in one of excell sheets i have formula in one cell. in this formula i have a reference to a cell whose row number is the data contained in another cell. how do i extract this data to reference my destination cell. thanking in advance |
#2
|
|||
|
|||
how do i use the data in one cell as the row number of another cel
See if this helps:
http://www.officearticles.com/excel/...ft_excel.h tm Your formula would be more like: =INDIRECT("C"&A1) So, if you have a 4 in cell A1, this will return the contents of C4. ************ Anne Troy www.OfficeArticles.com "vidhya" wrote in message ... hello in one of excell sheets i have formula in one cell. in this formula i have a reference to a cell whose row number is the data contained in another cell. how do i extract this data to reference my destination cell. thanking in advance |
#3
|
|||
|
|||
how do i use the data in one cell as the row number of another cel
Hi Try using in INDIRECT function. e.g.. A1=225 B1=A C1=1 to extract the value in A1 using both B1 and C1 has your reference then: =INDIRECT(B1&C1) or if you already know your column reference, "in this case A" then: =INDIRECT("A"&C1) HTH JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=476792 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Add data to cell w/o loosing initial data | Excel Discussion (Misc queries) | |||
Defining a number in a cell by text then subtracting it by the tex | Excel Worksheet Functions | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions |