Index and Match formula returns wrong values


Have two sheets. One holds the master data with an auto generated ID. The second sheet uses the index and match formula to fill out some row field data that is associated with a particular ID. All data that the formula fetches is contained on sheet one and each row has a unique auto generated number.

Some ID's return correct data while others do not yet all data is present and within row of the first sheet where the formula references.

What could be the issue good people