combining two if statements in one with a vlookup

Hi all, my formula works if I enter it individually but as soon as I combine into one then it adds instead of using the scenarios, any advice on how to bring two scenarios together in one formula?  ...