When I do the following

=INDEX(Sheet2!A3:D319,MATCH(SCHEDULING!B3,Sheet2!A3:A319,0),4)

I get this error

#N/A


Could someone please help me with this.

One reason might be this, but I don't know how to fix it.
In the MATCH(Scheduling B3) it is a number format.

In the Sheet2 column A field it was imported as a text format and i changed it to a number format. However after I changed it to a number format, and i went and retyped the number it worked, but it left a green arrow in the upper left corner of the cell with the formula.

So i might be able to retype these numbers to get them to work, but I dont really want to retype 1000 numbers every time the data refreshed because it is importing as text.

Any help would be great


Thanks
Josh