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

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" <(E-Mail Removed)> wrote in message
news:96F17DFA-3B84-4B20-83FA-(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> wrote in message
> news:96F17DFA-3B84-4B20-83FA-(E-Mail Removed)...
> > 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
>
>
>