| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),QuoteNotes, | Excel Worksheet Functions | |||
| =HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),Range ... ? | Excel Worksheet Functions | |||
| Return cell address of a cell based on contents of cell. | Excel Worksheet Functions | |||
| How make hyperlink refer to cell content rather than cell address. | Excel Discussion (Misc queries) | |||
| store cell contents and cell address for comparsion & suming | Excel Programming | |||
Linear Mode
