I have a problem making lookup dynamic such that if items in drop downs change the lookup should also change. I have spent over a week and no clue comes up. A friend suggested this site for me and I'm confident to have answers after reading some of answers provided. Anyone to help? You can please leave your email so I can send the spreadsheet and a telephone number to call.I'm in Ghana and would be more than ready to call to discuss.

Thanks
Zak

I suggest having groups of drop down lists relating to groups of lookup tables seperatly in the workbook.
Then create a set point for the drop down list and lookup table that will be used. These lists will be dynamic in so far as it refence the right group of drop down and lookup table.

Say you have Group A and B

When you want to use group A the user enters A in a specified cell, the set point drop down has the formula =if($B$1="A",+F2,+K2) where B1 is the cell where the user enters the list number he wants to use (A or B) do the same for the columns in the lookup field

Now your dropdown data validation will always reference the same list address and so also the lookup table - but these two references will change depending on the user input of A or B