Thanks AD
So simple? & works a treat.

"AD" wrote:

Hello,

Just add 2 to the column parameter of the address function,


=ADDRESS(MATCH(Date,A1:A312,0),MATCH(Name,A1:AF1,0 ) +2 ,4)


HTH

AD108


"LaDdIe" wrote in message
...
Hiya,

I have this in cell A319:
=ADDRESS(MATCH(Date,A1:A312,0),MATCH(Name,A1:AF1,0 ),4)

Which, just as an example returns B312.

In cell A320 I need a formula to returns the above B312 increased by 2
columns, as an example this would result in D312 in Cell A320.

(May have post this question twice in a few mins due to an error, sorry)

Happy Easter Holidays

LaDDie