Create Dependent Lists using an INDEX function??
 

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

Create Dependent Lists using an INDEX function??
 

Hi,

What does your INDIRECT function look like, exactly?
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Gemma" wrote:

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