Thread: Extract matched values from a query list to new sheet or column
View Single Post
 
Old 06-11-2023, 04:42 AM
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
Code:
=FILTER(Source!A2:E27,ISNUMBER(MATCH(TRIM(Source!D2:D27),Query!A2:A24,0)))
In any cell/sheet in the same workbook.
Reply With Quote