I am trying to create a formula which shows a different drop down list depending on the value of another cell, and basing this on vlookup


Example:

IF(A1=one, VLOOKUP(B1,tableone,4,TRUE),IF(A1=two, VLOOKUP(B1,tabletwo,4,TRUE),IF(A1=three, VLOOKUP(B1,tablethree,4,TRUE),IF(A1=four, VLOOKUP(B1,tablefour,4,TRUE)

The problem I have is A) the source box is so small it makes it very awkward seeing what you have inputted, and B) its quite long winded!

Does anyone have any suggestions on how I can make this easier to work with please?

I would upload but it is a huge spreadsheet!

Thanks in advance

Sam