Cell address

[LaDdIe]

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

 

[AD]

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]

Thanks AD
So simple? & works a treat.

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