Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Get row number from another cell
Instead of using the link: =Sheet1!A3 I would like the row number 3 to be taken from cell A1, something like =Sheet1!A(A1) but this doesn't work. Can anyone advise me of how to do this. Thanks -- DKerr ------------------------------------------------------------------------ DKerr's Profile: http://www.excelforum.com/member.php...o&userid=13087 View this thread: http://www.excelforum.com/showthread...hreadid=512170 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Get row number from another cell
Hi DKerr,
If cell A1 contains the value 3 =ADDRESS(A1,1) gives $A$3 =INDIRECT(ADDRESS(A1,1) ) gives the value in the cell $A$3 The key is the ADDRESS function, look it up in Help for more info. Ed Ferrero Microsoft Excel MVP http://www.edferrero.com Instead of using the link: =Sheet1!A3 I would like the row number 3 to be taken from cell A1, something like =Sheet1!A(A1) but this doesn't work. Can anyone advise me of how to do this. Thanks -- DKerr ------------------------------------------------------------------------ DKerr's Profile: http://www.excelforum.com/member.php...o&userid=13087 View this thread: http://www.excelforum.com/showthread...hreadid=512170 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Get row number from another cell
Think we could put it say, in Sheet2's B1:
=INDIRECT("'Sheet1'!A" & A1) where in (Sheet2's) A1: 3 The above would return the same as the link: =Sheet1!A3 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "DKerr" wrote in message ... Instead of using the link: =Sheet1!A3 I would like the row number 3 to be taken from cell A1, something like =Sheet1!A(A1) but this doesn't work. Can anyone advise me of how to do this. Thanks -- DKerr ------------------------------------------------------------------------ DKerr's Profile: http://www.excelforum.com/member.php...o&userid=13087 View this thread: http://www.excelforum.com/showthread...hreadid=512170 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Get row number from another cell
Thanks For both replies, Max's suggestion seems to work best for mee. -- DKerr ------------------------------------------------------------------------ DKerr's Profile: http://www.excelforum.com/member.php...o&userid=13087 View this thread: http://www.excelforum.com/showthread...hreadid=512170 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Get row number from another cell
You're welcome !
Thanks for the feedback -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "DKerr" wrote in message ... Thanks For both replies, Max's suggestion seems to work best for mee. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I make the number in one cell automatically appear elsewhere? | Excel Worksheet Functions | |||
First Number in a Cell | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
number formatted cell | Excel Discussion (Misc queries) | |||
Defining a number in a cell by text then subtracting it by the tex | Excel Worksheet Functions |