View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SteveG[_2_] SteveG[_2_] is offline
external usenet poster
 
Posts: 10
Default Data Validation List content controlled from cell

In the end I solved the problem myself!

I created a table with labels - each column representing a different
list.

Then with one cell "LIST" used to direct the choise of list I created
an OFFSET statement OFFSET(LIST,0,I10-1,4,1) that I used in the
VALIDATION list box (not forgetting to use an array input