I found a way around this by using a lot of hlookup functions and naming the ranges,

Thanks anyway.

Chris