I have two worksheets.

the first has 1 column of info that largely follows a trend of the data in
the coulumn incrementing by 1 as you go down.
the second has 2 coulumns. Most, but not all, the data in the first column
matches the data in column 1. Column 2 also has some data in it.

I want to populate the data in sheet one column 2 with the relevent data
from sheet 2 column 2 where there is a match with column 1.

how can I achieve this?

In sheet 1, cell B1 --

=VLOOKUP(A1,Sheet2!$A$1:$B$4,2,0)

Change Sheet2!$A$1:$B$4 to be the range on Sheet2 that contains your
data. Then copy this formula down.

Help on VLOOKUP will give you more information on the arguments that
VLOOKUP takes.

--
HTH,
Dianne

In ,
SS typed:
I have two worksheets.

the first has 1 column of info that largely follows a trend of the
data in the coulumn incrementing by 1 as you go down.
the second has 2 coulumns. Most, but not all, the data in the first
column matches the data in column 1. Column 2 also has some data in
it.

I want to populate the data in sheet one column 2 with the relevent
data from sheet 2 column 2 where there is a match with column 1.

how can I achieve this?

thanks - I'll look into this!