Change number based on specific cell with number

[Edd Chia]

How do i change a cell with number based on selected specific dropdown cell with number. Example, when i input a number in 'A1' 100, 'B1' automatic change to 125 and when i input another number in the same cell 'A1' 99, 'B1' auto change to 120. kindly assist me please.

Cell A Cell B
A1= 100 B1= 125
A1= 99 B1= 120
A1= 98 B1= 115
A1= 97 B1= 110
A1= 96 B1= 105
A1= 95 B1= 100
A1= 94 B1= 95

 

[villy]

You dont have to make your data validatin list with 2 columns it really not necessary just make A1:A20 sorry for my last post I didn't notice it was 2 columns it should work by then

 

[villy]

GoTo Data|Validation then in Allow field choose list then choose the range of sheet2 A1:A20

I did mention here that it the range is A1:A20 only.

IN A1:A20 of sheet 2 put the values from 100 down to whatsoever
and in column B1:B20 put the corresponding values like 125 down to whatsoever