Excellent trick when you should have Master/Detail lookup combo box in your Excel form. This is quite often needed. Here is an example:

On Master(Level1) value is choose from dropdown box.

Detail(Level2) Dropdown selection depends on Master(Level1)

While looking for easy, expandable way, I found one. Download sample excel file.

It uses "Named Ranges" extensively, very useful MS Excel feature. My comments to it:

  • top_1 - Range contains 1 row with all Master text cells
  • top2_ - Range contains 2 rows with Master text cells and Detail named range cells
  • (agro,production) - Ranges for Detail cells