How do i?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good evenin
I need to automatically change the value in a cell once i select a value in
another cell.
For example, if i have 3 values: a,b,c (using a drop down list in C1) and
3 values in D2(values:1,2,3) so when i select "a" in C1, the value in D2
should automatically change to "1" and so on for b=2,c=3.

Your prompt response will be greatly appreciated :) thank You!
 
Assuming it is simple like you say, then a formula in D2

=IF(C1="a",1,IF(C1="b",2,3))
 
Back
Top