|
|
|
|
#1
10-09-2018, 02:19 AM
|
|||
|
|||
Hi This is the further data from Pivot table (see tab Pivot contract expiration).
you will see that in Pivot table I have contract starting in 2011-2017-2018. I would be interested in having the contract expiration date in tab "final result" column "J4". With Vlokkup is only taking the 1st value which is finding 2017, how can i include the 2018 and 2011? Thanks 
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 VLookup or Index Multiple Tables
|
mycon73 | Excel | 4 | 07-27-2018 06:53 AM |
| Index/match, Vlookup? | kelwea | Excel | 1 | 01-24-2017 10:19 AM |
| Can I substitute Vlookup with Index | paxon | Excel | 4 | 03-10-2016 07:03 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 |
Windows XP 
Office 2007
Hybrid Mode