Return specific value based on string in text

I have one excel file where every year has a specific number against it. I want to automate the process and create a column which will return the stored value based on the year mentioned in string.

Salefile Fixed value
CS Tota 2016 batch20 23
CS 1040 (2017) 26
CS 1041 (2018) 30
CS 1040 (2019) 34

Here

I want a formula, any future entry for 2016, 2017 , 2018 or 2019 , the fixed value will automatically generate based on the year. Example if my next entry is 'CS Total 2017 batch 3" then under fixed value '26' will appear. I used:

=IF(ISNUMBER(SEARCH(" 2016 ",B5)),"23","")

How do I add 2017, 2018 and 2019 and automate the process.