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,

I would suggest you create a side table that contains the possibilities along with the match values to return...

then use a formula to extract...

see attached....

The formula in B1 is an array formula and must be confirmed with CTRL+SHIFT+ENTER not just ENTER.

Please post your question in a new thread... it is against rules to ask question in others' threads.