| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Indirect - Multiple Sheets/Cells
I have several sheets that I need to pull the information from cells K20,
K65, and K79 for each sheet. On a "Summary" sheet, I have listed the sheet names in Column A. So far I have tried using versions of an INDIRECT formula, but it does not consistently work (in fact, the few times it has worked, I can't figure out why)! Here's the formula I was using: =INDIRECT($A$2&"!"&"K20") Usually this formula comes back as #REF... What am I doing wrong???? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking cells on between multiple sheets | Excel Discussion (Misc queries) | |||
| INDIRECT and multiple sheets | Excel Worksheet Functions | |||
| how to sum cells from multiple work sheets | Excel Worksheet Functions | |||
| Sum Indirect function through multiple sheets | Excel Discussion (Misc queries) | |||
| count cells over multiple sheets | Excel Worksheet Functions | |||
Threaded Mode
