View Single Post
 
Old 01-12-2023, 05:58 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

There are 2 possible ways:
a) A classic one, like:
Code:
=FILTER(SourceSheetName!A2:D10,(SourceSheetName!A2:A10=H1)*(SourceSheetName!B2:B10=H2))
b) Named Table syntax (you must define the source table as Named one - e.g. naming it as SourceTable, to get it to work):
Code:
=FILTER(SourceTable,(SourceTable[SourceColumnHeader1]=H1)*(SourceTable[SourceColumnHeader2]=H2))
Reply With Quote