Thankyou Spencer just what I needed! ive come across this one as well =INDIRECT(ADDRESS(14,9,,,C$7)), it appears to just be a long winded way of doing it, is that fair to say?

Thanks again