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.

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.

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.

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.

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.