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