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

=?Utf-8?B?QkpSUGFya2Vy?=

Guest

Posts: n/a

6th Jul 2006

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,)),"")

« Developing macro event to allow multiple choices on drop down menu | Sheet name/number »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: cell contents from a reference	Chip Pearson	Microsoft Excel Misc	1	29th Dec 2009 06:28 AM
Can Excel recognise cell contents as a cell reference	sincln21	Microsoft Excel Misc	2	25th Feb 2009 02:31 PM
nested Cell("contents", w/ cell contents reference)	=?Utf-8?B?SkFTZWxlcA==?=	Microsoft Excel Worksheet Functions	1	19th Oct 2007 12:17 AM
excel displays cell contents but won't print cell contents	=?Utf-8?B?RGpq?=	Microsoft Excel Crashes	0	18th Nov 2005 01:56 AM
Cell only shows link in text, not contents of reference cell	=?Utf-8?B?SmF5IE1hYw==?=	Microsoft Excel New Users	4	23rd Aug 2005 08:36 PM