Hi,

I'm trying to pull the data from the access database based on the list box selection. For single select it is working fine, but for multiselect, I'm not able to get it

For single select i'm using the below index formula ( which refers number D) , and using the sql query "strSQL = strSQL & "Market = '" & wksSumMenu.Range("B3").Value" filtering the data from the access database.

=INDEX(B$5:B$10,MATCH(1,C$5:C$10,0))

For multiple select could you suggest me some logic on how to solve it.


Number List box selected
A 0
B 0
C 0
D 1
E 1
F 0


Thanks a lot for your help

Regards,
Ajay