I want to use INDEX with one part of the lookup range as a dynamic address
that I generate in a series of cells i.e.

MATCH(xxxx:A14093,278,3)

I cant get it to work because if the generated address such as A984 is
created in cell M1 and I put M1 were the xxxx is, the range interpreted by
MATCH is M1:A14093 not my desired A984:A14093. If I use INDIRECT(M1) I get
the contents of A984 not the address A984.

Any help will be much appreciated.

Vic