Conditionally replace x cells with y cells

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

Post Flair (click to view more posts with a particular flair)

unsolved

Post Body

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)

Author

Account Strength

80%

Account Age

6 years

Verified Email

Yes

Verified Flair

Total Karma

166

Link Karma

115

Comment Karma

Profile updated: 6 days ago

Posts updated: 1 year ago

somefakename117

Subreddit

r/excel

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.

Posted: 1 year ago
Reddit URL: View post on reddit.com
External URL: reddit.com/r/excel/comme...