Drop down, two tables and different values

[clueless41e]

Hi,

I want to be able to select at position A29, a drop down list. The options are from WEIGHT INDEX TABLE sheet, either table 9 DMI/AEH or 9 LD3/LD4. Once selected, I enter the value manually at D29 and this will provide me with the INDEX value at position G29. But at G29, the value must be able to distinguish between both 9 DMI/AEH or 9 LD3/LD4 values, depending which one I choose.

Hopefully that makes sense.

Thanks

 

[Rijnsent]

For a dropdown list, you're looking for "data validation", see e.g. this tutorial: Excel Data Validation Guide
For your second list (that is determined on the selection of your first item), see e.g. this tutorial: How to make dependent dropdown lists in Excel

Good luck!