Hey All,

I have made an index match formula that pulls a name from a series of IDs. The name that is pulled in the cell with the index match formula is also a named range that I want to make into a dependent drop down list. For some reason, when I make a drop down list using the indirect formula that references the cell with the index match formula in it (the value in that sell is the same as the named range), it doesn't work.

Does anyone know why this might be happening? As a test, I used the indirect formula referencing the cell with the index match formula in it, and it also gives me a #ref error.

Cheers,
B