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