I am trying to set up a sheet that will let me enter a number into a column
and it will fill in the second column. I know that is confussing, so here is
what I am trying to do...
Column A is like this
a1 1000
a2 2000
a3 3000
etc
Column B is
b1 99
b2 197
b3 296

what I want to do is type the number 2000 in on block (IE C1) and 197 auto
fills into another block (IE D1). I can get it to work if I type each
number, but I have about 300 to do.
Any help? Thanks