Thread: How do i use a cell contents to reference to a name in excel?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BJRParker BJRParker is offline
external usenet poster
  
Posts: 3
Default 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 With QuoteReply With Quote