the offset is useful for simplifying formulas when you want to define a range
for different purposes when the only one cell in the range is easily
identified.
for example
you might have a worksheet with a block of information about an individual
with the name in just the upper left cell in the block .the offset() could be
used to get information relative to the location of the name.

Because the offset can define a range, it can be used inside lookup()
formulas. or othe formulas


"Roger H" wrote:

When is it useful to use OFFSET function.
I'm not sure I understand exactly what it's for but think it may be useful!?