Thread: Create Dependent Lists using an INDEX function??
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Gemma Gemma is offline
external usenet poster
  
Posts: 4
Default 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
Reply With QuoteReply With Quote