Alt+Enter in Index Formula

[Guest]

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

 

[Tom Ogilvy]

See answer to original post.