FORMULA HELP

I am trying to nest together some references and I can not get it to work out.

The formula below works fine:
=INDIRECT(ADDRESS(MATCH(R[-5]C,C9,0),3),1)

The problem is that I need the C9 to be dymanic. I have the following
formula:
=MATCH(R[-4]C,R[-11]C[-9]:R[-11]C[-3],0)+3

That will give me the 9 for the C9, but I do not know the sysntax to replace
the C9 in the original formula.
The first formula is in cell M16 and the second is in cell M14..if it is
relevant.

Thanks

Not sure, but guess we could try this expression*
to replace "C9" in the formula in M16:

OFFSET(C[-12],,MATCH(R[-6]C,R[-13]C[-9]:R[-13]C[-3],0)+2)

*returns the required column 9, viz.: "I:I"

(M14 is no longer required)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"James McDowell" wrote in message
...
I am trying to nest together some references and I can not get it to work
out.

The formula below works fine:
=INDIRECT(ADDRESS(MATCH(R[-5]C,C9,0),3),1)

The problem is that I need the C9 to be dymanic. I have the following
formula:
=MATCH(R[-4]C,R[-11]C[-9]:R[-11]C[-3],0)+3

That will give me the 9 for the C9, but I do not know the sysntax to
replace
the C9 in the original formula.
The first formula is in cell M16 and the second is in cell M14..if it is
relevant.

Thanks

Not su

You can replace C9 with the following expression:

INDIRECT("C"&MATCH(R[-4]C,R[-11]C[-9]:R[-11]C[-3],0)+3,0)

Of course, your own INDIRECT is somehow producing an A1 reference in a
sheet where other formulas are in R1C1. I hope you are not as confused
using it as I am g. Good luck!

Does this help?

Kostis Vezerides