![]() |
#1
|
|||
|
|||
![]() Hi; with vlookup i can only get the 1st value that the formula found. in this case is only 2017. But what formula can I use if I want to show that there are several contracts expiring for the Client in sheet2? Ideally in sheet 1 column J I would like to see 2011, 2017, 2018 as there are multiple expiration date. (I have added manually in sheet1 column J4 the result I would like to see with the formula) Thanks |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |
![]() |
ruci1225 | Excel | 1 | 01-15-2012 07:31 AM |