I have a colleague who wants to use the Data Validation List function
to create a drop down list. Depending on where the list is used (21
different places on the spreadsheet) the contents of the list vary BUT
the original data is all in the same database.

The database looks like:

Position Item Variable_1 Variable_2 Variable_3
1 AAA 100 20 45
1 AAB 120 20 45
2 AAA 101 25 45
2 AAB 123 20 45
" " " " "
21 AAB 119 20 45

This looks like a kind of "Double Vlookup" ie. Lookup Position then
Item then Variables.

Anybody got a good idea how to do this?

Thanks

Steve

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