Forum Discussion
Index & Match Errors + warning Signs
Excel is not allowing me to add C5:C7 after the first comma of my formula, see error image that appears.
Any help would be appreciated as im using another computer to work as this fails.
JonTektos Perhaps the link below helps. You need to change the regional number formats in Windows.
You probably have a comma as the decimal symbol, a point as the digit grouping symbol and a semi-column as the list separator. Change that the point, comma, comma respectively.
4 Replies
JonTektos I suspect that you local settings expect a semi-colon to separate the elements within a formula. My system expects comma's. When I enter the formula with semi-colons, the message pops up after entering F5;
So, try this: =INDEX(D5:D7;MATCH(F5;C5:C7;0))
- Thank you, but I just want to use the comma and have no idea why a simple formula cannot be carried out.
How can i revert this odd setting.JonTektos Perhaps the link below helps. You need to change the regional number formats in Windows.
You probably have a comma as the decimal symbol, a point as the digit grouping symbol and a semi-column as the list separator. Change that the point, comma, comma respectively.
