Matching data between sheet based on criteria

Hi

I have a sheet with 2007 data I want to update with 2008 data (incom and tax) from another sheet. The unique post in both sheet is the company Vat number. So i want to use this cell to look up the new data. If it cant find the Company Vat number in the 2008 data, then it should keep the old data.

See uploaded example for details.

Thanks

Elad
Norway

Se uploaded example for details

Hi!

Thanks - se in your solution that you get it right, but I cant figure out how you do it... trying out the formula in my original sheets and I only get #I/T error.

In the solution, what does the formula in cell G6 in the Company 2008 sheet do?

Hi again.

It works fine now. I had not the excact same text between the collums, and after fixing that it worked!

Thanks very much!


Elad