Nov 26 2023 01:26 PM
Hello everyone !
I want to FILTER some data with a SPLITTED TABLE
File below:
https://www.cjoint.com/c/MKAvzCcgEjS
Thanks for your help !
Nov 26 2023 03:19 PM
SolutionIn K3:
=XLOOKUP(B3&","&C3,LISTS_ALL!$B$3:$B$2508&","&LISTS_ALL!$C$3:$C$2508, LISTS_ALL!$G$3:$H$2508&"","")
Nov 26 2023 03:19 PM
SolutionIn K3:
=XLOOKUP(B3&","&C3,LISTS_ALL!$B$3:$B$2508&","&LISTS_ALL!$C$3:$C$2508, LISTS_ALL!$G$3:$H$2508&"","")