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.

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.

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.

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