Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 10-09-2018, 02:19 AM
paxon paxon is offline Vlookup or Index for multiple rows? Windows XP Vlookup or Index for multiple rows? Office 2007
Novice
Vlookup or Index for multiple rows?
 
Join Date: Feb 2016
Posts: 13
paxon is on a distinguished road
Default

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
Attached Files
File Type: xlsx Supplier.xlsx (308.0 KB, 12 views)
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup or Index for multiple rows? 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 for multiple rows? Vlookup or Index/Match - Multiple Criteria ruci1225 Excel 1 01-15-2012 07:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:15 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft