| 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 | |||
Hybrid Mode
