Thread: extract data from table based on data from another table
View Single Post
 
Old 12-03-2023, 08:03 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2021
Expert
  
Join Date: Apr 2014
Posts: 956
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 the absence of a workbook:
Code:
=FILTER(TableA,ISNUMBER(MATCH(TableA[ID],TableB[ID],0)),"None found")
Reply With Quote