Alt+Enter in Index Formula
 

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???

Alt+Enter in Index Formula
 

See answer to original post.

--
Regards,
Tom Ogilvy


"NewBike" wrote in message
...
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???