I have 2 seperate data sets. The first gives a list of product codes and
a code. The second just gives the product code. e.g:

Dataset 1
Code Product code
01 02034953
01 02394685
01 04056606

02 05045677
02 05233456
02 90455439

03 04563956

Dataset 2

Product code
02034953
02394685
04056606
05045677
05233456
90455439
04563956

I want a way to get the code from dataset 1 to dataset 2(obviously
matching products). Copying and pasting won't work because some of the
product codes in dataset 1 are not included in dataset 2.

Thankyou for your help

Chris


--
cj21
------------------------------------------------------------------------
cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673
View this thread: http://www.excelforum.com/showthread...hreadid=506352