Hello, in the file attached, I am tryong to make this formula work : IFERROR(ABS(C$2-INDEX(H$7:NN$8, MATCH("x",H9:NN10,0))),0). I place it in cell G9, but I keep getting a message error, can you help me correct it?
Hello, in the file attached, I am tryong to make this formula work : IFERROR(ABS(C$2-INDEX(H$7:NN$8, MATCH("x",H9:NN10,0))),0). I place it in cell G9, but I keep getting a message error, can you help me correct it?
Your formula uses two-row ranges for both the MATCH and the INDEX ranges, and it isn't clear why. That's the source of your error. Try the following:
=IFERROR(ABS(C$2-INDEX(H$7:NN$7, MATCH("x",H9:NN9,0))),0)
If your problem has been solved, please use "Thread Tools" to mark the thread as "Solved".
If you're grateful for this site's existence and would like to contribute to the community, please consider posting something hilarious in our joke thread:
https://www.excelforum.com/the-water...ke-thread.html
Hello again, I have copied the formula but it still returns to a message error, I have now placed in the G9 cell, and removed the equal so that I may send you the file with the formula inside.
Does your PC have a French locale? If so, replace the commas in the formula with semi-colons.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Ah, good catch Ali! Je ne pense pas en français. Hopefully Ali's suggestion works, because the workbook is error-free for me?
Hello, that was exactly the issue. Thank you for solving
Glad we could help, good luck!
Glad to have helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks