Thread: Completely lost on formula - vlookup? Index/Match?
View Single Post
 
Old 12-19-2023, 05:52 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2021
Expert
  
Join Date: Apr 2014
Posts: 948
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