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 |
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 |