Search string for substring...return match

I get info from one of my suppliers, see attached.

I am trying to create an If-Then formula dealing with the number in the cell that is in blue font.

I am trying to get the formula to do something like:

If the cell contains a number (1 of 130 possibiliteis) then this cell equals (each of the 130 possibliteis has a corresponding answer)

So for the attached: IF the cell contains 451039336990, then this cell equals 1875.

Any help would be greatly appreciated.

If I need to clarify anything, please contact me at ajohnston@afvusa.com

Thank you,