| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I reference a worksheet in a formula based on a cell value
Row 1 contains labels / headings: A B C Sheet 1 Sheet 2 Sheet 3, etc. In row 2, part of the formula will look to a cell on the worksheet that corresponds to the heading. For example, "='Sheet 1'!A3+'Sheet 1'!A5" I'd like to "insert" the reference to the worksheet by referencing the cell in row 1. I think there must be an easy way to do it, and it would save me a lot of time. Thanks in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell reference in different worksheet in formula | Excel Worksheet Functions | |||
| What is the formula to reference a cell in a different worksheet? | Excel Worksheet Functions | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| formula to return the value of a cell based on a looked up true reference | Excel Worksheet Functions | |||
Threaded Mode
