Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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??? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I enter a formula, Excel shows the formula not the results | Excel Worksheet Functions | |||
Incorporating INDEX function into Array Formula (CNTRL-SHIFT-ENTER | Excel Worksheet Functions | |||
I cannot enter text in VBA search index | Excel Programming | |||
What does hitting Ctrl + Shift + Enter to enter a formula do??? Help a n00b out. | Excel Worksheet Functions | |||
Cannot enter formula in a cell after removing a circular formula | Excel Worksheet Functions |