Hi Barry

On sheet2 in cell B1 enter
=VLOOKUP(A1,Sheet1!A:B,2,0)
Copy down as far as required

--
Regards

Roger Govier


"Barry Walker" <Barry wrote in message
...
I have two sets of data (2 worksheets)

one set contains a column with 14000 different numbers and a second
column
with corresponding values to these numbers.

the second worksheet contains a column of numbers which are some
(7000) of
the numbers in the first worksheet.

I need to put the corresponding values from the first worksheet with
the
column of numbers in the second worksheet.

The only way I know how is to copy one at a time which is taking a
long time.

Does anyone know a quicker way?

Regards Barry