Forum Discussion
Solved
Fetching a value from a range depending on input
Hello, I have encountered an issue with a formula to calculate the price in my social entrepreneurship. Here is the simplified version. I enter the number of units in C4. Among other expenses, I hav...
Okay, it looks like i found. In MATCH it shall be A20:A99, not A20:B99. It works on one dimension array, not on matrix.
Okay, it looks like i found. In MATCH it shall be A20:A99, not A20:B99. It works on one dimension array, not on matrix.
It works. Thank you so much, it takes great skill to see the details. Much appreciated, thank you again. All the best.