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.
Strange, INDEX/MATCH shall work. Are you sure in A column you have numbers, not text?
- I have reformated all fields involved to numbers but it stayed the same.
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.
