| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Limitations ? Formatting and Size when exporting to Tab based Text file? | Excel Worksheet Functions | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) | |||
| Returning a Value to a Cell Based on a Range of Uncertain Size | Excel Worksheet Functions | |||
Linear Mode
