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

  • Thread starter Thread starter Ed
  • Start date Start date
E

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.
 
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
 
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
 
I got it, thanks.

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

Thanks again Paul!
 
Back
Top