Forum Discussion
Having a problem with Index Match formula. Keeps giving me a value error
Hello Community - I have an urgent business meeting and need to get this error fixed. My formula works perfectly if I just use two index match statements. When I add a third, it gives me a ...
I suspect that your problem lies in the use of IF rather than the INDEX/MATCH area. Have you tried the IFS function? It can often work more readily (and, not incidentally, be more readable) that having deeply nested IF functions.
Here's a helpful reference: https://exceljet.net/excel-functions/excel-ifs-function
If you still need help, may I suggest that you post a copy (or a representative sample) of your actual spreadsheet. Not an image, the actual spreadsheet, with rows and columns of representative data.