Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Completely lost on formula - vlookup? Index/Match?
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 12-19-2023, 05:52 PM
p45cal's Avatar
p45cal p45cal is offline Completely lost on formula - vlookup? Index/Match? Windows 10 Completely lost on formula - vlookup? Index/Match? Office 2021
Expert
  
Join Date: Apr 2014
Posts: 962
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
In cell A2 of the Output sheet:
Code:
=FILTER(CHOOSECOLS('Raw Data'!A2:H9,1,2,8),('Raw Data'!H2:H9>=H1)*('Raw Data'!H2:H9<=J1),"None")
Reply With Quote
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple match values for INDEX(MATCH) formula jn82740 Excel 1 06-24-2023 11:48 PM
Index/match, Vlookup? kelwea Excel 1 01-24-2017 10:19 AM
Completely lost on formula - vlookup? Index/Match? Index / Match / Vlookup - correct formulae prom101 Excel 4 01-20-2017 03:31 PM
Match Index with sumproduct/vlookup angie.chang Excel 1 06-18-2012 08:47 AM
Completely lost on formula - vlookup? Index/Match? 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 01:39 PM.

Contact Us - Privacy Statement - Top

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