LOOKUP VALUE with SPLITTED TABLE

[Boulakgnobot]

Hello everyone !

I want to FILTER some data with a SPLITTED TABLE

File below:

https://www.cjoint.com/c/MKAvzCcgEjS

Thanks for your help !

[#2 · Accepted solution]

@Boulakgnobot 

In K3:

=XLOOKUP(B3&","&C3,LISTS_ALL!$B$3:$B$2508&","&LISTS_ALL!$C$3:$C$2508, LISTS_ALL!$G$3:$H$2508&"","")

[#3]

Thanks a lot for your HELP !