Hi,

I've looked all over the internet and this website for this issue, but can't find an adequate answer. Does anyone know how to have a reference to a cell that contains the name of the named range that I want to use in my Index & match formula? So Index(NamedRange,match(a value, a random list,0)) is working, but I want to have a cell in the formula instead of NamedRange. INDIRECT didn't work and I have no other clues.. Thanks