offset

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Rick said:
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.
Click to expand...

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

---
 
Back
Top