|
|
#1
10-01-2018, 05:31 AM
|
|||
|
|||
Vlookup or Index for multiple rows?
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 
|
|
|
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
Threaded Mode