Referencing a cell based on the value in another cell
Hi all, I have issues. What I want to do, if possible, is reference a particular cell by using the value in another cell. So for example, if I have the following: A B C 1 9 3 2 8 3 7 4 6 5 5 =WhatIWant What I want to be able to do is have another cell somewhere else that will reference one of the cells A1:5, and that cell is determined by cell C1. So as it is above, WhatIWant should equal the value in A3 because C1=3, but if I change C1 to a different number, WhatIWant should change as well. Any ideas? -- septillion ------------------------------------------------------------------------ septillion's Profile: http://www.excelforum.com/member.php...o&userid=35882 View this thread: http://www.excelforum.com/showthread...hreadid=556762 |
Referencing a cell based on the value in another cell
Hi!
Try one of these: =INDEX(A1:A5,C1) =INDIRECT("A"&C1) You might want to make sure C1 has a value entered into it: =IF(C1="","",INDEX(A1:A5,C1)) =IF(C1="","",INDIRECT("A"&C1)) Biff "septillion" wrote in message ... Hi all, I have issues. What I want to do, if possible, is reference a particular cell by using the value in another cell. So for example, if I have the following: A B C 1 9 3 2 8 3 7 4 6 5 5 =WhatIWant What I want to be able to do is have another cell somewhere else that will reference one of the cells A1:5, and that cell is determined by cell C1. So as it is above, WhatIWant should equal the value in A3 because C1=3, but if I change C1 to a different number, WhatIWant should change as well. Any ideas? -- septillion ------------------------------------------------------------------------ septillion's Profile: http://www.excelforum.com/member.php...o&userid=35882 View this thread: http://www.excelforum.com/showthread...hreadid=556762 |
Referencing a cell based on the value in another cell
Yep, that worked. Cheers, much obliged. -- septillion ------------------------------------------------------------------------ septillion's Profile: http://www.excelforum.com/member.php...o&userid=35882 View this thread: http://www.excelforum.com/showthread...hreadid=556762 |
Referencing a cell based on the value in another cell
You're welcome!
Biff "septillion" wrote in message ... Yep, that worked. Cheers, much obliged. -- septillion ------------------------------------------------------------------------ septillion's Profile: http://www.excelforum.com/member.php...o&userid=35882 View this thread: http://www.excelforum.com/showthread...hreadid=556762 |
All times are GMT +1. The time now is 11:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com