Alt+Enter in Index Formula

's Computer Specifications

Hi all,
I have the following formula:
=INDEX('[Spreadsheet.xls]Status'!$A:$B,MATCH(N18,'[Spreadsheet.xls]Status'!$A:$A,0),2)

that pulls information from "spreadsheet" into "destination". Formula works
great EXCEPT when data is entered with Alt+Enter when there are multiple
serial numbers for an item in the row.

Is there a way to index the data in my source column even when Alt+Enter is
used???

's Computer Specifications

See answer to original post.

--
Regards,
Tom Ogilvy

"NewBike" <(E-Mail Removed)> wrote in message
news:472A8A3D-035E-4B1E-92DC-(E-Mail Removed)...
> Hi all,
> I have the following formula:
> =INDEX('[Spreadsheet.xls]Status'!$A:$B,MATCH(N18,'[Spreadsheet.xls]Status'!$A:$A,0),2)
>
> that pulls information from "spreadsheet" into "destination". Formula
> works
> great EXCEPT when data is entered with Alt+Enter when there are multiple
> serial numbers for an item in the row.
>
> Is there a way to index the data in my source column even when Alt+Enter
> is
> used???

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Incorporating INDEX function into Array Formula (CNTRL-SHIFT-ENTER	=?Utf-8?B?RXhjZWxNb25rZXk=?=	Microsoft Excel Worksheet Functions	4	5th Feb 2007 08:01 PM
I cannot enter text in VBA search index	=?Utf-8?B?bWRtYWNraWxsb3A=?=	Microsoft Excel Programming	1	3rd Oct 2006 10:02 PM
How to I enter more than one subentry at a time in an index?	=?Utf-8?B?YmFuZHl3b3Jkcw==?=	Microsoft Word Document Management	1	27th Apr 2006 05:10 PM
What does hitting Ctrl + Shift + Enter to enter a formula do??? Help a n00b out.	qwopzxnm	Microsoft Excel Worksheet Functions	2	20th Oct 2005 09:06 PM
How do I enter an index entry with colon in text (C:N ratio)?	=?Utf-8?B?SW5kZXggZW50cnkgdy9jb2xvbiBpbiB0ZXh0IChD	Microsoft Word Document Management	2	14th May 2005 11:58 PM