| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data and the "IF" formula
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data and the "IF" formula
Hi 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: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data and the "IF" formula
Thanks 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. "Sige" wrote: Hi 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: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data and the "IF" formula
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 Weight Moment Weight Moment ---------------------------------------------------- 2 1000 99 ---------------------------------------------------- 3 2000 197 --------------------------------------------------- "Jeff" wrote: Thanks 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. "Sige" wrote: Hi 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: 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data and the "IF" formula
Sige's formula looks spot on to me.
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Jeff" wrote in message ... 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 Weight Moment Weight Moment ---------------------------------------------------- 2 1000 99 ---------------------------------------------------- 3 2000 197 --------------------------------------------------- "Jeff" wrote: Thanks 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. "Sige" wrote: Hi 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: 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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data and the "IF" formula
Change the ";" in the formula to ","
=VLOOKUP(C1,A:B,2,;FALSE) "Jeff" wrote: Thanks 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. "Sige" wrote: Hi 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: 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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data and the "IF" formula
oops ..
=VLOOKUP(C1,A:B,2,FALSE) "Toppers" wrote: Change the ";" in the formula to "," =VLOOKUP(C1,A:B,2,;FALSE) "Jeff" wrote: Thanks 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. "Sige" wrote: Hi 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: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
