INDEX(MATCH( Producing Incorrect Result in Cross-Sheet Reference

SaraSmilesPro

I have looked at a few of these similar questions and answers, but nothing quite matches what is going on with my sheets.

As managers of different branches send in information about their fleet vehicles, through a form, the data populates in a sheet.

I would like to link the cells in the master Fleet Management sheet to the data collected in the Manager form sheet.

As an example, I have the Column "Registration Received", which has the options of 4 colored balls (Red, Yellow, Green, Grey). This column is in both sheets. On the master sheet I currently have the formula:

=INDEX({Fleet Management - Manager Input Record Range 2}, MATCH("361", {Fleet Management - Manager Input Record Range 1}))

where "Fleet Management - Manager Input Record Range 2" references the colored balls column "Registration Received", and "Fleet Management - Manager Input Record Range 1" references the Primary Column, with lists the "Unit #".

Currently the Manager Input sheet states that 361 has a Red ball, but the master Fleet Management sheet populates a Yellow ball in that corresponding cell.

There are multiple Units that have a Yellow ball in that Manager Input Sheet, but 361 and one other truck are Red. These are both not populating Red on the master list.

Could the formula somehow be referencing something else I am unaware of?

SaraSmilesPro