want to autopopulate dropdown values

In Template Sheet, if I select Brand(H) , corresponding Model(I) has to autopopulate and if I select Model(I) ,corresponding Type(J) has to autopopulate.

In VehData sheet following are the columns.
H,I,J,N,O

This data are dynamic. Application generating this data.
Brand can have multiple models and models can have multiple types.
kindly help on this.

Can you either supply the password for the protected sheet, or re-upload the workbook with no password protection.

NBVC said:

Can you either supply the password for the protected sheet, or re-upload the workbook with no password protection.

Click to expand...

Actuall first uploaded one is application generation basing on VehUploadTemplate.xls which i have uploaded now.

thx for your reply

not sure what is wrong with your named ranges...

First rename the BrandModelTable as BMT by creating a new Named Range referencing the table, then use this in data validation for Model

=OFFSET(INDEX(BMT,MATCH(H2,INDEX(BMT,0,1),0),2),,,COUNTIF(INDEX(BMT,0,1),H2),1)

NBVC said:

not sure what is wrong with your named ranges...

First rename the BrandModelTable as BMT by creating a new Named Range referencing the table, then use this in data validation for Model

=OFFSET(INDEX(BMT,MATCH(H2,INDEX(BMT,0,1),0),2),,,COUNTIF(INDEX(BMT,0,1),H2),1)

Click to expand...

Thank you .

But this has not served my requirement .
Below is worked for me.
=OFFSET(VehData!$I$1,MATCH(Template!D16,BrandModelTable[Brand],0),1,COUNTIF(BrandModelTable[Brand],Template!D16),1)