![]() |
|
|
|
#1
|
|||
|
|||
|
Cheers Jeffrey, an eloquent solution. I didnt want to use a pivot as people (managers) tend to think of such things as "dark arts" that wnat nothing to do with.
Very much appreciated |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel - Index and Match Function ,First Second and Third Match | paulzy95 | Excel | 10 | 09-29-2016 10:46 PM |
| Vlookup and Match | ExcelVlookup | Excel | 4 | 06-22-2015 01:42 AM |
vlookup or match
|
uhlersa | Excel | 2 | 12-04-2012 12:35 AM |
| Match Index with sumproduct/vlookup | angie.chang | Excel | 1 | 06-18-2012 08:47 AM |
Vlookup or Index/Match - Multiple Criteria
|
ruci1225 | Excel | 1 | 01-15-2012 07:31 AM |