Create Dependent Lists using an INDEX function??

  • Thread starter Thread starter Gemma
  • Start date Start date
G

Gemma

I am a really rookie when it comes to Excel but have managed to create an
order form with three drop down lists using the INDIRECT function and the
instructions on the following wonderful page:

http://www.contextures.com/xlDataVal02.html#TwoWord

My problem is that I want to convert the spreadsheet into a webpage and the
Spreadsheet Convertor does not support the INDIRECT function. It suggests
using the INDEX function instead.

Could anyone point me in the right direction.

Many thanks
 
Back
Top