| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to reference a cell depending on the value in another cell??
Hi, I want to retrieve the data in a a cell in Sheet2, based on the value of
a cell in Sheet1. How do I do this? For example, in Sheet1, cell A1 has the value "5". In cell A2, I want it to retrieve the data in cell B5 of Sheet2 (the 5 coming from the value in cell A1). Thus, if I change the value in cell A1 to 6, cell A2 should then retrieve the data of the in cell B6 in Sheet2. The code in cell A2 would be something like: =Sheet2!B(Sheet1!A1) but of course that syntax doesn't work!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I reference a range of cells depending on another cell valu | Excel Discussion (Misc queries) | |||
| Copy content of cell to another depending on value of third cell(between worksheets) | Excel Worksheet Functions | |||
| Dynamically locking a cell depending upon value of another cell. | Excel Discussion (Misc queries) | |||
| How can i change cell colour depending on month of date in cell? | Excel Discussion (Misc queries) | |||
| problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
Threaded Mode
