Cell address
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 |
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 |
Cell address
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 |
All times are GMT +1. The time now is 12:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com