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
Or
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)
new-employee.xlsx
JaysonJacksonAsked:
Who is Participating?
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.

Thanks
Rob H
0

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.
0
ProfessorJimJamCommented:
Rob,

you are making good scores these days :-)

questions are answered by you on the fly
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

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.
0
ProfessorJimJamCommented:
Great!
0
Rob HensonFinance AnalystCommented:
New job starts next Monday so probably won't see much from me for a while after that.
0
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.