| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array reference using indirect address
I need to reference only the first cell of an array on a different worksheet
using a value in a cell on the current worksheet: Current Worksheet Cell B11 contains text from another function which is a cell reference i.e AB13 I am trying to create a VLookup array on a different worksheet: =VLOOKUP(8,Details!AB13:CT13,70) I know I need to somehow replace the AB13 with &B11, but I cannot get it to work correctly. Thanks for the help.... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
| =(INDIRECT(ADDRESS(ROW(),#))) with SUMPRODUCT returning #VALUE! | Excel Worksheet Functions | |||
| INDIRECT(ADDRESS... Across worksheets | Excel Worksheet Functions | |||
| Indirect and Address in Reference to other sheets | Excel Worksheet Functions | |||
| Address func in array reference | Excel Worksheet Functions | |||
Threaded Mode
