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