Sorry, I should've been more clear. The data starts in Column A Row 11.
However the data that I need will always be in row 11 and in the third to the
last column of data.

"Barb Reinhardt" wrote:

I'm going to redo this. I'm assuming that you have data in row 1 from column
1 over to wherever you want to go. If not, this may not work. The last
response I assumed you wanted to go to the last POSSIBLE column on the
worksheet (which I've never used)

=OFFSET(A1,0,COUNTA(1:1)-2)
--
HTH,
Barb Reinhardt



"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