Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dependent lists - error?? | Excel Discussion (Misc queries) | |||
Dependent Lists in Excel | Excel Worksheet Functions | |||
Dependent dropdown lists | Excel Discussion (Misc queries) | |||
Dependent lists | Excel Worksheet Functions | |||
Data Validation - Create dependent lists | Excel Discussion (Misc queries) |