Quote Originally Posted by raala12 View Post
Dear Experts,

I have lets' say 5 3 vehicles. Car ,Van Jeep. when you type the vehicle name in sheet1 row 1 cell1,next cell should give you the spare part drop down. e.g tyre, lamp,seats . when you select the sapre next cell dropdown should give you the specification . e.g you select jeep -> tyre then next cell dropdown tyre size 30',32',34' .

when you select jeep->tyre-> 32" then next cell give its price. for that in a different sheet, we have a table like this

vehicle |spare | specification | price

car ......... Tyre ......... 30 ........ $10
car ......... Tyre ......... 32 ........ $12
car ......... Tyre......... 34 ........ $12
......

jeep .............. seat ............ normal .......... $20
jeep .............. seat ............. leather ......... $25

......

so depending upon the user select combination of sheet1 row1 cell 1,2,3 ,sheet 1 cell 4
should automatically fill its price (by referring sheet 2 table )

e.g
you select jeep seat leather as the sheet1 row1 cell 1,2,3 values , then sheet 1 cell 4 should fill its value as $25

please give me a way
I know how to make dependent dropdownlists. But tell me a way to fill its price automatically based on our selected combination.

thanks .
use Excel Filters.....
http://www.contextures.com/xlautofilter01.html