| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matrix lookup/mulitple criteria lookup | Excel Discussion (Misc queries) | |||
| Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
| Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
| Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
| Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
Linear Mode
