Formula for populating data from another sheet into a scrollable table

[tyuio]

Hey there,

I currently have a sheet build (let's call it a dashboard), where there is an an area that pre-populates data from a master table and is scrollable using a form control bar. In the designated scrollable area, this is the current array formula:


=IFERROR(IF($L$28="",OFFSET('Master Data'!B2, ($F$2-1),0),INDEX(tbl_data,SMALL(IF(tbl_data=$L$28,ROW(tbl_data)-1),$F2),MATCH(G$1,tbl_data[#Headers],0))),"")


L28 is location selection
L29 is product selection

F1-O1 are the header cells for the scrollable area.
F Column contains the "record #" // Formula =$F2+1

Right now the formula is showing all the master data for me if L28 is blank, and filters data shown only for a specific location if L28 has a location selected. I am having issues trying to add the second criteria for more "data filtered" if L29 has a selection. I have tried something like this, but to no avail:


=IFERROR(IF($L$28="",OFFSET('Master Data'!B2, ($F$2-1),0),INDEX(tbl_data,SMALL(IF((tbl_data=$L$28)*(tbl_data=$L$29),ROW(tbl_data)-1),$F2),MATCH(G$1,tbl_data[#Headers],0))),"")


Sorry, this workbook has a sensitive information so it can't be shared but I really appreciate any help I can get and thank you in advance!