Lookup Help!

S

stan

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
 
P

Pete_UK

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
 
B

Barb Reinhardt

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)
 
S

stan

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.
 
Top