Help with If-Then Statements/Populating Data based upon selection
 

I would like to include a drop down in my excel spreadsheet that would
consist of 4 choices. Based upon which choice is selected, I would then like
specific data to populate elsewhere in the worksheet. So, for instance, if
my 4 choices are Julie, Tom, Rick, and Debbie, if someone selects Julie,
information about Julie will populate in all of my other fields. The data
about Julie is already in another worksheet. Is there a way that I can use
an if-then statement to pull this information over? Or, is there another way
to do this?

Thanks!

Help with If-Then Statements/Populating Data based upon selection
 

Check out Vlookup() in help

"SK" wrote:

I would like to include a drop down in my excel spreadsheet that would
consist of 4 choices. Based upon which choice is selected, I would then like
specific data to populate elsewhere in the worksheet. So, for instance, if
my 4 choices are Julie, Tom, Rick, and Debbie, if someone selects Julie,
information about Julie will populate in all of my other fields. The data
about Julie is already in another worksheet. Is there a way that I can use
an if-then statement to pull this information over? Or, is there another way
to do this?

Thanks!