Odd behavior with Index(Match

Using a basic Index(Match on 1 criteria to cross reference 2 sheets. I've checked multiple times that 1) the cells pulling in are actual numbers (no formulas), and 2) there is a MATCH to pull in.

Here is the formula - appreciate help on what I'm missing

=INDEX({Equipment Leadtime - MPTs MVA Limit}, MATCH([MPT Supplier]@row, {Equipment Leadtime MPT - Supplier}), 0)

{Equipment Leadtime - MPT MVA Limit} is this range on the source sheet. In the Source Sheet this is data that is manually inputted as #:

[MPT Supplier]@row is a drop-down cell which Data Shuttle upload populates for us. Here I've confirmed the NAMES are as brought in from the Source Sheet which is the same sheet shown above where {Equipment Leadtime - MPT MVA Limit} comes from.

{Equipment Leadtime MPT - Supplier} is literally the same cell the data shuttle creates the drop down in the target sheet above from - so the names definitely match.

What is ODD with having both sheets up to watch the results change as I change the MPT Supplier in the drop-down on the target sheet to make sure there is indeed data is some MPT Supplier names bring in the data…others give a NO MATCH even though I can see the Match.

TARGET SHEET WITH INDEX(MATCH formula

and the Match from the Source Sheet…

I'm sure this is simple but I'm on a deadline - appreciate pointing out my silly mistake.