INDEX & MATCH vs OFFSET & MATCH

[andrewc]

Hi,

I understand that you can create very flexible lookups by linking either the INDEX or OFFSET functions with the MATCH function.

Are these options equally effective or is one pair better than the other?

Thanks