Easy one for you guys...please help

rcpalmer

New Member
Joined
Apr 25, 2003
Messages
28
I tried seraching for this and maybe I was searching for the wrong thing but didn't come across anything that I thought would do the trick. This seems pretty simple but I can't figure out the excel way to do this.

I have a spreadhseet that has to be emailed back and forth between departments and one part of the spreadsheet has information I would like to auto populate.

It looks like this

Shop:
Street Address:
City, State:
Phone #:
Contact:
EMail Address:


I would like to have a drop down menu for the shop cell and have the other cells prepopulate with the correct information about that shop. There are about 30 shops total that I have all the information for, I just dont want to have to type it in everytime.

Please help!!

:biggrin:
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Sorry

Going to be one of those days I am afraid...thanks, of course vlookup will work...had a brain fart...Thanks!!
 
Upvote 0
You need to create a list with all the shops on sheet 2.
A1 shop name B1 Street Address C1 City etc etc.
In cell A1 on Sheet 1 enter
Shop Name
In cell A2 enter
=VLOOKUP(A1,Sheet2!$A$1:$G$30,2,0)
In cell A3 enter
=VLOOKUP(A1,Sheet2!$A$1:$G$30,3,0)

etc. etc.


Michael
 
Upvote 0

Forum statistics

Threads
1,217,758
Messages
6,138,437
Members
450,137
Latest member
HANHAN

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top