software

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? ThanksHi Jeff,

Maybe this is what you are after
=VLOOKUP(C1;A:B;2;FALSE) in D1

fill down in D2, D3, etc

HTH Sige

Jeff wrote:
gt; I am trying to set up a sheet that will let me enter a number into a column
gt; and it will fill in the second column. I know that is confussing, so here is
gt; what I am trying to do...
gt; Column A is like this
gt; a1 1000
gt; a2 2000
gt; a3 3000
gt; etc
gt; Column B is
gt; b1 99
gt; b2 197
gt; b3 296
gt;
gt; what I want to do is type the number 2000 in on block (IE C1) and 197 auto
gt; fills into another block (IE D1). I can get it to work if I type each
gt; number, but I have about 300 to do.
gt; Any help? ThanksThanks for the help, but it doesn't seem to like the formula. It says there
is an error in the formula and it Highlights the C1.

quot;Sigequot; wrote:

gt; Hi Jeff,
gt;
gt; Maybe this is what you are after
gt; =VLOOKUP(C1;A:B;2;FALSE) in D1
gt;
gt; fill down in D2, D3, etc
gt;
gt; HTH Sige
gt;
gt; Jeff wrote:
gt; gt; I am trying to set up a sheet that will let me enter a number into a column
gt; gt; and it will fill in the second column. I know that is confussing, so here is
gt; gt; what I am trying to do...
gt; gt; Column A is like this
gt; gt; a1 1000
gt; gt; a2 2000
gt; gt; a3 3000
gt; gt; etc
gt; gt; Column B is
gt; gt; b1 99
gt; gt; b2 197
gt; gt; b3 296
gt; gt;
gt; gt; what I want to do is type the number 2000 in on block (IE C1) and 197 auto
gt; gt; fills into another block (IE D1). I can get it to work if I type each
gt; gt; number, but I have about 300 to do.
gt; gt; Any help? Thanks
gt;
gt;

Maybe if I lay it out like this it will help
I want to enter the number 1000 (A2) in C2 and have 99(B2) auto show in D2.
I hope that makes a little more sense.
Thanks again for the help.
Jeff

__A________B________C_________D______
1 WeightMomentWeightMoment
----------------------------------------------------
2 100099
----------------------------------------------------
3 2000197
---------------------------------------------------quot;Jeffquot; wrote:

gt; Thanks for the help, but it doesn't seem to like the formula. It says there
gt; is an error in the formula and it Highlights the C1.
gt;
gt; quot;Sigequot; wrote:
gt;
gt; gt; Hi Jeff,
gt; gt;
gt; gt; Maybe this is what you are after
gt; gt; =VLOOKUP(C1;A:B;2;FALSE) in D1
gt; gt;
gt; gt; fill down in D2, D3, etc
gt; gt;
gt; gt; HTH Sige
gt; gt;
gt; gt; Jeff wrote:
gt; gt; gt; I am trying to set up a sheet that will let me enter a number into a column
gt; gt; gt; and it will fill in the second column. I know that is confussing, so here is
gt; gt; gt; what I am trying to do...
gt; gt; gt; Column A is like this
gt; gt; gt; a1 1000
gt; gt; gt; a2 2000
gt; gt; gt; a3 3000
gt; gt; gt; etc
gt; gt; gt; Column B is
gt; gt; gt; b1 99
gt; gt; gt; b2 197
gt; gt; gt; b3 296
gt; gt; gt;
gt; gt; gt; what I want to do is type the number 2000 in on block (IE C1) and 197 auto
gt; gt; gt; fills into another block (IE D1). I can get it to work if I type each
gt; gt; gt; number, but I have about 300 to do.
gt; gt; gt; Any help? Thanks
gt; gt;
gt; gt;

Sige's formula looks spot on to me.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Jeffquot; gt; wrote in message
...
gt; Maybe if I lay it out like this it will help
gt; I want to enter the number 1000 (A2) in C2 and have 99(B2) auto show in
D2.
gt; I hope that makes a little more sense.
gt; Thanks again for the help.
gt; Jeff
gt;
gt; __A________B________C_________D______
gt; 1 Weight Moment Weight Moment
gt; ----------------------------------------------------
gt; 2 1000 99
gt; ----------------------------------------------------
gt; 3 2000 197
gt; ---------------------------------------------------
gt;
gt;
gt; quot;Jeffquot; wrote:
gt;
gt; gt; Thanks for the help, but it doesn't seem to like the formula. It says
there
gt; gt; is an error in the formula and it Highlights the C1.
gt; gt;
gt; gt; quot;Sigequot; wrote:
gt; gt;
gt; gt; gt; Hi Jeff,
gt; gt; gt;
gt; gt; gt; Maybe this is what you are after
gt; gt; gt; =VLOOKUP(C1;A:B;2;FALSE) in D1
gt; gt; gt;
gt; gt; gt; fill down in D2, D3, etc
gt; gt; gt;
gt; gt; gt; HTH Sige
gt; gt; gt;
gt; gt; gt; Jeff wrote:
gt; gt; gt; gt; I am trying to set up a sheet that will let me enter a number into a
column
gt; gt; gt; gt; and it will fill in the second column. I know that is confussing,
so here is
gt; gt; gt; gt; what I am trying to do...
gt; gt; gt; gt; Column A is like this
gt; gt; gt; gt; a1 1000
gt; gt; gt; gt; a2 2000
gt; gt; gt; gt; a3 3000
gt; gt; gt; gt; etc
gt; gt; gt; gt; Column B is
gt; gt; gt; gt; b1 99
gt; gt; gt; gt; b2 197
gt; gt; gt; gt; b3 296
gt; gt; gt; gt;
gt; gt; gt; gt; what I want to do is type the number 2000 in on block (IE C1) and
197 auto
gt; gt; gt; gt; fills into another block (IE D1). I can get it to work if I type
each
gt; gt; gt; gt; number, but I have about 300 to do.
gt; gt; gt; gt; Any help? Thanks
gt; gt; gt;
gt; gt; gt;
Change the quot;;quot; in the formula to quot;,quot;

=VLOOKUP(C1,A:B,2,;FALSE)

quot;Jeffquot; wrote:

gt; Thanks for the help, but it doesn't seem to like the formula. It says there
gt; is an error in the formula and it Highlights the C1.
gt;
gt; quot;Sigequot; wrote:
gt;
gt; gt; Hi Jeff,
gt; gt;
gt; gt; Maybe this is what you are after
gt; gt; =VLOOKUP(C1;A:B;2;FALSE) in D1
gt; gt;
gt; gt; fill down in D2, D3, etc
gt; gt;
gt; gt; HTH Sige
gt; gt;
gt; gt; Jeff wrote:
gt; gt; gt; I am trying to set up a sheet that will let me enter a number into a column
gt; gt; gt; and it will fill in the second column. I know that is confussing, so here is
gt; gt; gt; what I am trying to do...
gt; gt; gt; Column A is like this
gt; gt; gt; a1 1000
gt; gt; gt; a2 2000
gt; gt; gt; a3 3000
gt; gt; gt; etc
gt; gt; gt; Column B is
gt; gt; gt; b1 99
gt; gt; gt; b2 197
gt; gt; gt; b3 296
gt; gt; gt;
gt; gt; gt; what I want to do is type the number 2000 in on block (IE C1) and 197 auto
gt; gt; gt; fills into another block (IE D1). I can get it to work if I type each
gt; gt; gt; number, but I have about 300 to do.
gt; gt; gt; Any help? Thanks
gt; gt;
gt; gt;

oops ..
=VLOOKUP(C1,A:B,2,FALSE)

quot;Toppersquot; wrote:

gt; Change the quot;;quot; in the formula to quot;,quot;
gt;
gt; =VLOOKUP(C1,A:B,2,;FALSE)
gt;
gt; quot;Jeffquot; wrote:
gt;
gt; gt; Thanks for the help, but it doesn't seem to like the formula. It says there
gt; gt; is an error in the formula and it Highlights the C1.
gt; gt;
gt; gt; quot;Sigequot; wrote:
gt; gt;
gt; gt; gt; Hi Jeff,
gt; gt; gt;
gt; gt; gt; Maybe this is what you are after
gt; gt; gt; =VLOOKUP(C1;A:B;2;FALSE) in D1
gt; gt; gt;
gt; gt; gt; fill down in D2, D3, etc
gt; gt; gt;
gt; gt; gt; HTH Sige
gt; gt; gt;
gt; gt; gt; Jeff wrote:
gt; gt; gt; gt; I am trying to set up a sheet that will let me enter a number into a column
gt; gt; gt; gt; and it will fill in the second column. I know that is confussing, so here is
gt; gt; gt; gt; what I am trying to do...
gt; gt; gt; gt; Column A is like this
gt; gt; gt; gt; a1 1000
gt; gt; gt; gt; a2 2000
gt; gt; gt; gt; a3 3000
gt; gt; gt; gt; etc
gt; gt; gt; gt; Column B is
gt; gt; gt; gt; b1 99
gt; gt; gt; gt; b2 197
gt; gt; gt; gt; b3 296
gt; gt; gt; gt;
gt; gt; gt; gt; what I want to do is type the number 2000 in on block (IE C1) and 197 auto
gt; gt; gt; gt; fills into another block (IE D1). I can get it to work if I type each
gt; gt; gt; gt; number, but I have about 300 to do.
gt; gt; gt; gt; Any help? Thanks
gt; gt; gt;
gt; gt; gt;