Thread: Cell address
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LaDdIe LaDdIe is offline
external usenet poster
 
Posts: 131
Default 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