If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
help with formulas, don't know where to start!
I have to worksheets and I need to bring numbers from one Worksheet to the
ohter kind of like this: worksheet one looks like this column a column b 1 20 2 21 3 22 4 23 worksheet2: column a column b 3 2 4 1 I need to populate in col b of worksheet 2 the numbes from col b of worksheet 1. |
#2
|
|||
|
|||
help with formulas, don't know where to start!
A VLOOKUP function should do the trick
On worksheet 2 use this for the formula in B1 =VLOOKUP(A1,worksheet1!$A$1:$B$4,2,False) Copy down as needed -- If this helps, please remember to click yes. "Ed" wrote: I have to worksheets and I need to bring numbers from one Worksheet to the ohter kind of like this: worksheet one looks like this column a column b 1 20 2 21 3 22 4 23 worksheet2: column a column b 3 2 4 1 I need to populate in col b of worksheet 2 the numbes from col b of worksheet 1. |
#3
|
|||
|
|||
help with formulas, don't know where to start!
Thank you Paul C.
That worked great. Now, can you explain how it works, I actually have over 10,000 cells where I need to do it and only works on the first 4. :-). Thaks again for your help "Paul C" wrote: A VLOOKUP function should do the trick On worksheet 2 use this for the formula in B1 =VLOOKUP(A1,worksheet1!$A$1:$B$4,2,False) Copy down as needed -- If this helps, please remember to click yes. "Ed" wrote: I have to worksheets and I need to bring numbers from one Worksheet to the ohter kind of like this: worksheet one looks like this column a column b 1 20 2 21 3 22 4 23 worksheet2: column a column b 3 2 4 1 I need to populate in col b of worksheet 2 the numbes from col b of worksheet 1. |
#4
|
|||
|
|||
help with formulas, don't know where to start!
Change the lookup table range to $A$1:$B$10000
Gord Dibben MS Excel MVP On Tue, 11 May 2010 09:56:01 -0700, Ed wrote: Thank you Paul C. That worked great. Now, can you explain how it works, I actually have over 10,000 cells where I need to do it and only works on the first 4. :-). Thaks again for your help "Paul C" wrote: A VLOOKUP function should do the trick On worksheet 2 use this for the formula in B1 =VLOOKUP(A1,worksheet1!$A$1:$B$4,2,False) Copy down as needed -- If this helps, please remember to click yes. "Ed" wrote: I have to worksheets and I need to bring numbers from one Worksheet to the ohter kind of like this: worksheet one looks like this column a column b 1 20 2 21 3 22 4 23 worksheet2: column a column b 3 2 4 1 I need to populate in col b of worksheet 2 the numbes from col b of worksheet 1. |
#5
|
|||
|
|||
help with formulas, don't know where to start!
I got it, thanks.
4 is the range on worksheet one, i changed it to 10,008 and it worked. Thanks again Paul! "Ed" wrote: Thank you Paul C. That worked great. Now, can you explain how it works, I actually have over 10,000 cells where I need to do it and only works on the first 4. :-). Thaks again for your help "Paul C" wrote: A VLOOKUP function should do the trick On worksheet 2 use this for the formula in B1 =VLOOKUP(A1,worksheet1!$A$1:$B$4,2,False) Copy down as needed -- If this helps, please remember to click yes. "Ed" wrote: I have to worksheets and I need to bring numbers from one Worksheet to the ohter kind of like this: worksheet one looks like this column a column b 1 20 2 21 3 22 4 23 worksheet2: column a column b 3 2 4 1 I need to populate in col b of worksheet 2 the numbes from col b of worksheet 1. |
Thread Tools | |
Display Modes | |
|
|