I have a list of products, with corresponding trade values. e.g.

Product..Value
0123456 20
0132463 30
0148743 100
0245674 66
0237857 1000
0334626 3442
0435267 10234

I also have another list of products(which i call an "exceptions"
list), most of which are included above, however some are not. e.g

0123456
0148743
0237857
0912486

I want a formula that copies the trade value from list1 to list
2-sought of matching, so it would look like:

0123456 20
0148743 100
0237857 1000
0912486 0

Note the last product is not in list 1 so it gets a zero value.

Any formulas to do this.

Thanks for the help

Chris


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