Cell address
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
|