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