SOLVED

LOOKUP VALUE with SPLITTED TABLE

Brass Contributor

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 Replies
best response confirmed by Sergei Baklan (MVP)
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&"","")

Thanks a lot for your HELP !
1 best response

Accepted Solutions
best response confirmed by Sergei Baklan (MVP)
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&"","")

View solution in original post