Hi

I have 2 tabs.

The first tab includes the following data

Product Code
NO*929125923
ESB35107911
ZA*894038981
NO*929125925
NL201442890000
GB00424948
GB00884749


The second tab has more detail

Product Code Total Assets1997 Total Assets1998
NO*929125923 234 25
ESB35107911 24
ZA*894038981 356 245
GB00884749 5356 23
GB004806293 356 25
GB02352403 36 2354

I need a formula in the first tab that searches for the product code and then puts in total assets. So my 1st tab would look like:


Product Code Total Assets1997 Total Assets1998
NO*929125923 234 25
ESB35107911 24
ZA*894038981 356 245
NO*929125925 0 0
NL201442890000 0 0
GB00424948 0 0
GB00884749 0 0


In reality there are lots of product codes!

Thanks for your help!