| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Indirect with COLUMN
Hello,
Trying to use the INDIRECT function to allow me to use a drop list, and based on my choice, I bring the data from a similarly name worksheet. This data resides in the same place on all worksheets. In the formula below, I have the worksheet name and the column and row. You can see I'm struggling with getting the column to return as a letter, rather than a number.... Is there a better way than having to manually enter the column reference? Thanks. =INDIRECT($AM$1&"!$ao"&(ROW())) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
| INDIRECT | Excel Worksheet Functions | |||
| Making column reference in INDIRECT non-static | Excel Worksheet Functions | |||
| Copying a formulae down a column that includes an INDIRECT | Excel Discussion (Misc queries) | |||
| Indirect Help | Excel Worksheet Functions | |||
Threaded Mode
