|
|
#2
12-11-2023, 04:27 AM
|
|||
|
|||
Something like this?
I added a column for numbering rows into source table, and removed spaces from 2 column names there. And placed the result table on separate sheet. On sheet with result table, I moved dates to Named Range at top of sheet, and added non-formula headers to result table, which allowed the result table to be defined as Table too. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Multiple match values for INDEX(MATCH) formula | jn82740 | Excel | 1 | 06-24-2023 11:48 PM |
| Excel Index and Match function with multiple criteria not searching the next record | mushtaqkadar | Excel | 3 | 06-17-2017 12:20 AM |
| UDF multiple IFs INDEX-MATCH | grexcelman | Excel Programming | 0 | 02-22-2015 04:20 PM |
| Help with multiple match and index formula | ryanwood | Excel | 1 | 09-12-2012 07:53 AM |
 Vlookup or Index/Match - Multiple Criteria
|
ruci1225 | Excel | 1 | 01-15-2012 07:31 AM |
Windows 8 
Office 2016
Threaded Mode