I have three individual lists and I am using a formula like this for each of them =OFFSET(Table1,MATCH(F15,Table1,0)-1,1,COUNTIF(Table1,F15),1)
for my final cell I need to create another data validation list which is depenant on the values selected in the previous three lists.. any idea how I would alter the formula to allow me to do that? I tried using and after the match to match all three tables but it never worked
Bookmarks