Hi Guys,

I have an excel Error with the following formula: =INDEX('Sheet1'!$E$7:$E$1025;MATCH($E64;'Sheet 2'!$G$7:$G$1025;0))

The error is input related I think, as the cell content makes or breaks it.

E.g. the current contents, that return a #VALUE! error are: (the XXX is just normal text, no special characters etc.)

"XXX, e.g.:
1. XXX,
2. XXX,
3. XXX,
To (I) XXX, (II) XXX, (III) XXX, (IV) XXX, XXX / XXX, XXX"

However, if I change the text to let's say "Apple", it does return the correct contents.

Anyone know why this happens?

I tried removing the Alt enters, the 1. or (I), but the same things happen - it is only when I put a simple and completely other input that it works