Thanks Mangesh - but I get a problem that the formula gets too long, and Excel truncates it.

I'm referring to an external sheet which has quite a long address, which does not help. I have to use this file, as it's the central sales sheet.

I'd normally use a string of vlookups, but can't do this because of the above reason.

Many thanks for your help,

Chris