I would like for a column to automatically fill in a correlating piece of
information depending on data I type into a separate column. For example: in
column A I type in "4001", the column B would automatically fill in
"Driving". Bonus points if you can tell me how I could have a drop down menu
for the first column's info and still get the autofill in the second column.
Thanks!

Use a VLOOKUP() Table. See:

http://www.contextures.com/xlFunctions02.html
--
Gary''s Student - gsnu200768


"jimmiller17" wrote:

I would like for a column to automatically fill in a correlating piece of
information depending on data I type into a separate column. For example: in
column A I type in "4001", the column B would automatically fill in
"Driving". Bonus points if you can tell me how I could have a drop down menu
for the first column's info and still get the autofill in the second column.
Thanks!

Hi

Take a look at Debra Dalgleish's site
http://www.contextures.com/xlDataVal02.html

--
Regards
Roger Govier

"jimmiller17" wrote in message
...
I would like for a column to automatically fill in a correlating piece of
information depending on data I type into a separate column. For example:
in
column A I type in "4001", the column B would automatically fill in
"Driving". Bonus points if you can tell me how I could have a drop down
menu
for the first column's info and still get the autofill in the second
column.
Thanks!