In U$17$ use NESTED IF functions to enter:

the value in AG$2,$ if the PROVINCE is ON$,$

the value in AG$3,$ if the PROVINCE is BC$,$

the value in AG$4,$ if the PROVINCE is AB$,$

the value in AG$5,$ if the PROVINCE is MB$,$

otherwise the value in AG$6.$