I am having problem with my =INDEX formula
I am using =INDEX(L2:L30;MATCH(B4;K2:K30;0))
the problem is that not all shows up. if the value is letter, the formula works fine but if it is number the i am getting #N/A results
fyi: I am trimming the text first, I tried to use =left formula and =trim formula but both have the same problem


TRIM FORMULA PROBLEM.xlsx