Match Function for Split Numbers

I have couple of numbers into a cell (Column "A") and I have separated them in columns "B" and "C". My problem is: When I use from MATCH function (F2), there is the error on cell (Please see attached excel file). But if I use copy and paste of data, I can reach to true answer. How can I remove the error?
Thanks in advance for your help.

The numbers in Columns B and C are being seen as Text while the number in E2 is being seen as a number.

You have two options, change columns B and C to numbers or change E2 to text.

Option 1:
B2 =IFERROR(LEFT(A1,FIND(" ",A1))+0,0)
C2 =IFERROR(RIGHT(A1,LEN(A1)-FIND(" ",A1))+0,"")
Keep F2 the same.

Option 2:
F2 =MATCH(E2&"",C1:C20,0)
Keep columns B and C the same.