Greetings!
Suppose I have a table:
A 3 6
B 4 8
C 5 12 etc
I have created a drop down list for (A,B,C) in say cell A2. Now when I select in A2 cell value A from drop down list I want B2 cell to show 3 and C3 to show 6. Similarly if I select A2=C, then I want B2=5 and C2=12. How do I do this for a large amount of data say 1500 values in each column?
Please help.
Satish
Bookmarks