Lookup Help!
 

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

Lookup Help!
 

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

Lookup Help!
 

Try this

=OFFSET(A1,0,COLUMNS(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

Lookup Help!
 

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

Lookup Help!
 

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