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.