Hello everybody,
I have a problem to finish my exercise, there are three lists (listA, listB, listC) and three cells (H1), (L1), (M1).
A B C
1 listA listB listC
2 40 40 40
3 45 45 60
4 50 40 30
5 50 50 70
6 50 50 120
7 60 40 30
8 60 40 40
If I select cell H1=60 (belong to listA) , L1=40 (belong to listB), M1 should be a dropdown list that returns two values:40 and 30 (belong to listC)
what i have to type on the Source of dropdown list?
thank you very much in advance
Bookmarks