Formual to go to a specific column?

[shiftyspina]

Hi All

Is there a way to go to a specific column i excel? My data ranges from Column A to Column TP and rather than using find, or scrolling along to find the column i want, i want to know if i can put a date in A1 for example and it will go straight to that column?

I have used a macro before to filter horizontally, but thats not going to work in this case, i just want to go straight to that column labelled "05/03/2014" for example

Is this possible?

Dan

[XOR LX]

Hi,

Perhaps with a hyperlink in cell B1? For example, assuming your headers range from G1:O1, and you wish to go to the column whose header corresponds to the entry in A1:

=HYPERLINK("#"&ADDRESS(1,MIN(COLUMN(G1:O1))+MATCH(A1,G1:O1,0)-1),"Go")

Regards

[adyteo]

check the attached file
Attachment 302032

[shiftyspina]

Thank you both, thats done exactly what i needed, thank you