Hi Vic,

Try this...

If cell M1 is containing the start address of your range, replace xxxx with
indirect(M1).

Are you sure about the use of the match function: lookup_up_value, array,
type.

Wkr,

JP



"Vic Waller" wrote in message
. 131...
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