| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do i use a cell contents to reference to a name in excel?
In the following formula (from SHEET2!) rather than Index just the ANSI150
array, i want to Index an array named in another cell that might be anyone of a number of arrays names. eg I have both a ANSI150 and ANSI300 array and i want to return the result based on which one of these is in another cell - say B18 on the SHEET2! =IF(A180,INDEX('Gasket Calculation.xls'!ANSI150,MATCH(C18,Sheet1!$A$6:$A$ 26,),MATCH("iD",Sheet1!$A$6:$H$6,)),"") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| VBA Excel Macro to delete contents in named cell | Excel Discussion (Misc queries) | |||
| Can you reference a cell that is sorted in excel 2002? | Excel Worksheet Functions | |||
| hide cell contents and make it reappear (Excel) | Excel Discussion (Misc queries) | |||
| How do I reference every "n" cell in a column in Excel? | Excel Worksheet Functions | |||
Linear Mode
