Hi! I need to figure out how to populate neighboring cells when an option is
selected in a drop down box. For instance, I have a table with data and I
have a new worksheet with drop downs so I can choose something from column A
on that table. I would like for the next two columns in my new worksheet to
populate with the information from column B and C in the table when an item
in the drop down menu is choosen.

Can you help?

Thanks so much!