Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-23-2017, 02:05 PM
kelwea kelwea is offline Index/match, Vlookup? Mac OS X Index/match, Vlookup? Office 2016
Novice
Index/match, Vlookup?
 
Join Date: Jan 2017
Posts: 5
kelwea is on a distinguished road
Default Index/match, Vlookup?

Please see attached sample spreadsheet. I am trying to find the correct formula that will scan the info in 'Test' worksheet and copy the corresponding row of information from 'Test' worksheet to the correct '<Days' worksheet based on the date in Column I. So, if the date in column I is less than 30 days from today, then copy that row to the corresponding sheet, etc. Any help is greatly appreciated.
Attached Files
File Type: xlsx Copy of G3 CUOPS Task Tracker.xlsx (44.1 KB, 11 views)
Reply With Quote
  #2  
Old 01-24-2017, 10:19 AM
xor xor is offline Index/match, Vlookup? Windows 10 Index/match, Vlookup? Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Is it like the attached?
Attached Files
File Type: xlsx G3 CUOPS Task Tracker_2.xlsx (69.8 KB, 10 views)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Index/match, Vlookup? Index / Match / Vlookup - correct formulae prom101 Excel 4 01-20-2017 03:31 PM
Excel - Index and Match Function ,First Second and Third Match paulzy95 Excel 10 09-29-2016 10:46 PM
Index/match, Vlookup? 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
Index/match, Vlookup? 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 03:52 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