| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Invalid Formula with the use of Indirect
Hi. I'm not sure why it causes the error. The formula is: =VLOOKUP(A1, INDIRECT($C$15), 2, 1) =VLOOKUP(A2, INDIRECT($C$15), 2, 1) =VLOOKUP(A3, INDIRECT($C$15), 2, 1) Cells A1 to A3 contain the values to lookup. Cell C15 contains =ADDRESS(ROW(C5),COLUMN(C5), 4) &":"& ADDRESS(ROW(C14),COLUMN(C14), 4) =C5:C14 [answer display] It won't work! :( Error: #REF! I need to use the INDIRECT function because I need a dynamic reference (the table). The table is being constantly updated. How to solve this problem? Or is there any alternative to do the same thing? -- Additional information: - I'm using Office XP - I'm using Windows XP |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup + indirect formula | Excel Discussion (Misc queries) | |||
| Formula Contains an invalid external reference to a worksheet | Setting up and Configuration of Excel | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Indirect formula using Data Validation List of Worksheet Tabs | Excel Worksheet Functions | |||
| Indirect used in an array formula | Excel Worksheet Functions | |||
Threaded Mode
