Look up data in another sheet

[elad]

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

[deemo]

Something like looking up the vatnr in the 2008 table and if you don't find it you look it up in the 2007 table?

=IF(ISERR(VLOOKUP(vatnr,2008table,2,FALSE)),VLOOKUP(vatnr,2007table,2,FALSE),VLOOKUP(vatnr,2008table,2,FALSE))

[elad]

Hi

It looks like that will help me out.

Thank you very much!

Elad