help with formulas, don't know where to start!

[Ed]

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.

 

[Paul C]

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

 

[Ed]

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

 

[Gord Dibben]

Change the lookup table range to $A$1:$B$10000


Gord Dibben MS Excel MVP

 

[Ed]

I got it, thanks.

4 is the range on worksheet one, i changed it to 10,008 and it worked.

Thanks again Paul!