Using Index Match function to create multi dependent drop down lists - Returning Error

Hi all,

I created a multi dependent drop down list across 3 columns successfully using the INDEX MATCH function. I've added new data and created named ranges, and the formula is now returning an error. There are 2 active tabs in the workbook:

1) selection worksheet with multi column dropdowns
2) master look up data worksheet

When I used a direct array formula for the cells, the dropdown brought back the right data:

FORMULA: =INDEX('Master Table Lookup'!$B$8:$F$12,,MATCH($A5,Products,0))

I then created named ranges and changed the formula:

FORMULA: =INDEX(MasterTable[[Mobile Clinic]:[Travel, Reporting and Misc]],MATCH($A5,MasterTable[Product Stream],0))

I'm getting an error now when initially it worked. There are some blank rows in the names ranges (2nd formula) - not sure if this is creating an issue.

Any help would be much appreciated.

Thanks in advance - have spent far too many hours working through this. Your valued expertise is much needed

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

No workbook yet ...

Yes - oddly it's saying it's loaded but not showing as uploaded? Got it