Rather than "third to the last column" of data, can you express this
as a column number? If so then you can use the INDEX function.

Hope this helps.

Pete

On Aug 5, 10:17*pm, stan wrote:
Hello,

I'm trying to find the value in the first row of the third to the last
column of data. *How would I go about writing a formula that would look this
up for me? *Any help would be greatly appreciated! *

Thanks