set drop-down list values based on a cell value

[Shafique]

Item Input Table Entry Table SR # Name Type Size Price Date: Item Name Type Size Price 1 Fuels Diesel N/A 109 01-Dec OIL ? ? 2 Fuels Petrol N/A 100 3 Bearings Ball 6206 65 4 Disc Cutting Disc 4" 200 5 OIL Mobil Oil Barrel 3600 6 OIL Hydraulic Oil Cane 490 7 OIL Break Oil Cane 490 8 I set a drop down list in entry table's item name column it shows the names from Item input table's name column. But I have same Item names with different types. Here I want to set another drop down list in entry table's type column who show only those item types that I select in item names. and also with its type's size and its size's price. <colgroup><col><col><col><col span="5"><col><col span="6"></colgroup><tbody> </tbody> <strike></strike>

<colgroup><col><col><col><col span="5"><col><col span="3"></colgroup><tbody>
</tbody>

 

[Kamolga]

Hi,

One of the way to have dependant dropdowns is to have lists for each item and name them (formula tab, define name) with the item name. So yo have an oil list with the 3 oils that you name oil. Now if the item name is in g2, you make a drodown list and in source you type

=indirect(g2)

Personnally I always make my lists in tables (insert tab, table), name the content of the table oil, and then if I add an oil later to the list, it will automatically extend and it will automatically be available in te dropdown.

Now if you have fuels in g2 and a list called fuels somewhere in te workbook, your list will show fuels list