How do i use a cell contents to reference to a name in excel?

B

BJRParker

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(A18>0,INDEX('Gasket
Calculation.xls'!ANSI150,MATCH(C18,Sheet1!$A$6:$A$26,),MATCH("iD",Sheet1!$A$6:$H$6,)),"")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index Match to ignore blank cells 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Vlookup and return sheet name also 2
Excel - Wich Function should I use? 1
INDEX return multiple columns 1
Word macro that can call cells out of Excel for a find and replace 0
use month in cell date to sum all relevant cells 2
Adding cells until they are greater than a lookup cell and returning a value 1

Top