Indice + corresp

[Vinhas]

Hi ,

i don't understand why the value in "I8" is not the same that is in "E14".
It appears the formula just read the first letter. What I can modify to appears in "I8" the value of "98" corresponding at the value in "E14"??

Many thanks in advance

[CARACALLA]

I4=INDEX($E$4:$E$14,MATCH(H4,$D$4:$D$14,0))


0= exact match

Copy down