Forum Discussion
Index & Match Errors + warning Signs
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.
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))
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.
Riny_van_Eekelen Your a star IT support set up the machine in Hong Kong both language & region hence the ;
Now reverted back to english all sorted thank you