Thread: offset
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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.