I have strings of text with words and numbers in column A that contain a specific numbers (25,31,36.....80). I want to assign a numeric value in a column B based on the specific value found in the aforementioned string of text in column A. I came up with the function below but it only seems to return the value of "14.20" or the first value based on finding the value of "25" in the selected string. Once it gets to the other values in the list, like "31", and even if the string contains it, I get #Value!. Thank you


=IF(FIND("25",B3),"14.20",IF(FIND("31",B3),"16.73",IF(FIND("36",B3),"17.74",IF(FIND("39",B3),"19.54",IF(FIND("43",B3),"20.29",IF(FIND("48",B3),"21.99",IF(FIND("52",B3),"23.52",IF(FIND("55",B3),"24.91",IF(FIND("60",B3),"26.61",IF(FIND("64",B3),"29.07",IF(FIND("67",B3),"30.76",IF(FIND("72",B3),"32.45",IF(FIND("75",B3),"33.31",IF(FIND("80",B3),"34.16"))))))))))))))