| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can INDIRECT return a range array?
What I'm trying to do is use a INDIRECT function to return an range array so
a MATCH funtion can look into that range and find a value for me. eg. MATCH("Grand Total", INDIRECT("A1:A10"), 0) This is part of a much larger formula and it's returning an N/A and I can only assume that it's this part that is wrong as the rest seems to work in isolation. Any ideas that could help at all please guys. TIA. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return based on range of dates | Excel Worksheet Functions | |||
| Range Name from Another Workbook conflicts with INDEX and INDIRECT | Excel Worksheet Functions | |||
| return a range of cells from a vertical lookup | Excel Worksheet Functions | |||
| Array Formula, noncontigous range | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Threaded Mode
