MS excel 2010

I am trying to setup a spread sheet that will have the following:

If  New Hire is selected from H9  I want B 15  to display DOB: (MM/DD/YYYY)  (DOB is entered in B16)
And  E15 to display SSN  (data is entered in E16)  See attached

What I am trying to have this do.  is if  
Termination is selected you do not see B15/B16 or E15/E16
When change is Selected
B15 says “Current Role”  (this will be a drop down H27 – H35)
E16 will say “New Role”  (this will use the same drop down as above)
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rob HensonFinance AnalystCommented:
Formula in B15:

=IF($H$9="New Hire","DOB: (MM/DD/YYYY)",IF($H$9="Change","Current Role",""))

Formula in E15:

=IF($H$9="New Hire","SSN",IF($H$9="Change","New Role",""))

Then set Data Validation in B16 and E16 to look at list of Roles; like you ahve in H9 for list of reasons.

Rob H

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
JaysonJacksonAuthor Commented:
Awesome. thank you.
ProfessorJimJamMicrosoft Excel ExpertCommented:

you are making good scores these days :-)

questions are answered by you on the fly
Introduction to Web Design

Develop a strong foundation and understanding of web design by learning HTML, CSS, and additional tools to help you develop your own website.

Rob HensonFinance AnalystCommented:
Changing jobs and have handed over a lot of things to successor so have more time to spend on EE, rather than just break time.
ProfessorJimJamMicrosoft Excel ExpertCommented:
Rob HensonFinance AnalystCommented:
New job starts next Monday so probably won't see much from me for a while after that.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.