Named range in Index & Match

Originally Posted by jason.b75

How is your named range defined?

If it doesn't evaluate correctly for any reason then it will affect any formula that try to use it.

If it is defined correctly then you should be able to use =INDEX(INDIRECT(A1),etc... where the name of the named range to use is entered into A1.

edit:-

Look at E1 in your example, the cell is formatted to show "Year1" but the value in the cell is just "1" so INDIRECT(E1) is looking for a non existent range named "1"

Great, thanks!