Excel AutoFill

Basic excel question. How do I have cells auto populate based on another cells value. Example if the user enters Baseball then another field will enter a Y for team sport.

Thank you.

Jamie PooleDigital Specialist Asked:
Who is Participating?
 
TracyConnect With a Mentor VBA DeveloperCommented:
You can use an event which requires code, or you can use a formula.

So if column A has Baseball and you want Y in column B, then enter this formula and drag down:

=If(A1="Baseball","Y","")

This will autopopulate column B with a Y when you enter in Baseball in column A.  When something else is entered or nothing at all then column B remains blank.
0
 
Jamie PooleDigital Specialist Author Commented:
Thank you I knew it was simple I just don't have that much experience with Excel.
0
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.

All Courses

From novice to tech pro — start learning today.