| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
offset
I want to find the word Total located in column A, the word total will move
but does stay in A, and return the total value located in column B next to the word Total. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
offset
=VLOOKUP("Total",A:B,2,0)
-- Regards, Peo Sjoblom "Rick" wrote in message ... I want to find the word Total located in column A, the word total will move but does stay in A, and return the total value located in column B next to the word Total. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
offset
=SUMIF(A:A,"Total",B:B)
"Rick" wrote: I want to find the word Total located in column A, the word total will move but does stay in A, and return the total value located in column B next to the word Total. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
offset
"Rick" wrote:
I want to find the word Total located in column A, the word total will move but does stay in A, and return the total value located in column B next to the word Total. Eyeing the hint in your subject line, an alternative* play using OFFSET In C1: =OFFSET(B1,MATCH("Total",A:A,0)-1,) *but not necessarily better -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul | Excel Worksheet Functions | |||
| Offset | Excel Discussion (Misc queries) | |||
| OFFSET | Excel Worksheet Functions | |||
| Offset | Excel Worksheet Functions | |||
| VBA help with Offset | Excel Discussion (Misc queries) | |||
Linear Mode
