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:
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

rcpalmer

New Member
Joined
Apr 25, 2003
Messages
28
Sorry

Going to be one of those days I am afraid...thanks, of course vlookup will work...had a brain fart...Thanks!!
 

daniels012

Well-known Member
Joined
Jan 13, 2005
Messages
5,219
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,369
Messages
5,595,760
Members
414,017
Latest member
surajks

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
Top