Forum Discussion
Solved
Defined names change when looking them up in the name box
Hi, I'm having some trouble when defining a name to a search function. I go to defined names, add name, let's say ANA that refers to =MAX(A1:A32). When I click in another cell and in the name bo...
- In Spanish Excel, the formula should be:
=DESREF(Hoja1!$A$1:$A$1000;COINCIDIR(MAX(Hoja1!$A$1:$A$1000);Hoja1!$A$1:$A$1000;0)-1;0;1;1)
See: https://en.excel-translator.de/translator/
What if you would set ANA to be "=MAX($A$1:$A$32)". That will fix the range to A1:A32. Whenever you call for ANA in a formula, it will give you the highest value in that range.
Yes sorry, I forgot to put the dollar signs, but that is not my problem. If I set ANA to =MAX($B$1:$B12), and then I click on cell C4 and in the name box I look for ANA. The value of ANA gets changed to C4.
I was successful in one Excel book, but whenever I try to do that again, it does not work.
- What are you trying to achieve exactly?
To be able to find with the name box my desired value, so when I have a thousand results I can just get the cell where that value is.
