Create Dependent Lists using an INDEX function??

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list from index/match formula 1
Using INDIRECT Function and INDEX Function 1
Multiple items selected multiple dependancies available 3
Indirect function help 2
Excel -- Data Validation -- Create Dependent Lists 6
Build Team in a Project Detail Page? 0
Data Validation-Dependent Lists 2
stumped on creating dependent data validation lists 1

Top