Index Match error

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

Done, 365 indeed, apologies

Originally Posted by TMS

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

Hi Trevor, apologies,

Awesome thank you AliGW, do you perhaps know of any workarounds?