Data Validation / Offset Formula

[usmanfarok]

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

[Fotis1991]

Hi

You need depanted data validation for this.

http://www.contextures.com/xlDataVal02.html

[usmanfarok]

can i create two indirect functions in there??

one for type and one for catagory

[Fotis1991]

..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)

So In B6 you choose "NBF". Then where do you want to have the option "TR or LC"? And then, where the Type & Category. In the same cell?

[usmanfarok]

i have 7 banks in total (NBF, ADCB, HSBC ETC)

Every Bank offering two types of services LC & TR

But for every bank the sub type of LC and TR are different for example for HSBC have three subs in TR catagory but in NBF there are 7 subs in TR.

so what i want to do is if i select NBF it show me either LC or TR, if TR selected then 7 Subs, but if i select HSBC it should only Show me 5 Subs.

i think i made it clear enough.

Thanks in Advance for helping.

Usman

[usmanfarok]

So In B6 you choose "NBF". Then where do you want to have the option "TR or LC"? And then, where the Type & Category. In the same cell?

Please consider sheet one as an example (full is raw form which i m working to reform, that's why it will confuse you)

[Fotis1991]

Hi

I did an example in your worksheet, only for 2 banks. NBF and Barclays.

Use same way and for the others.

Are you Ok with this?