I am currently working on a project and pretty new to Excel. I have a drop down to select Yes or No to view certain work projects. If yes I would like it to replace the cells below (which are blank) with 20-40 of the cells I have in the bottom of the document and if No those cells would stay blank. My idea is something along these lines but l'm not sure how to write it into excel...

IF A2 = "Yes" Replace A4-B14 with A22-B27

IF A3 = "Yes" Replace A4-B14 with D22-E27

And so on for about 5 different choices

IF all are No Replace A4-B-14 with “ “ or blank cells

(If possible without nesting a bunch of IF functions in each cell, and the example is a simple version of what I’m working on, there is no way for yes to be selected for more than 1)