Data Validation / Offset Formula

i am doing data validation and have two col interlink with each other, how can i connect three col's with data validation

so if a select a specific bank it should show me "Type" just for that bank and "Services" based on the type col

so if the bank id is "NBF" in Services it should show me " TR or LC " once made the selection of LC or TR it should show me what is the sub category of TR or LC (already connected Type and category)

Sample file Included Please see tab "Sheet1"

Thanks In Advance

Usman