Adding second criteria (if not blank) to this formula

[tyuio]

=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, in this scrollable populating data area, the formula is showing all the master data for me if L28 is blank,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 it doesn't work:


=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!

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/excel...data-another-sheet-into-scrollable-table.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.