defining an array for INDEX

D

Dave F

The following returns cell addres F9 in the worksheet "Cap, Deprn &
COF Summary": =CELL("address",INDEX('Cap, Deprn & COF Summary'!
B9:R9,MATCH(E3,'Cap, Deprn & COF Summary'!B9:R9,0)))

I want to use this cell address as the basis for an array to use with
the INDEX function. Assume I want to use the array F9:F12 in the
worksheet referenced above.

How could I incorporate the above into the INDEX syntax?

Thanks,

Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top