What's my line???

americanpie3

Board Regular
Joined
Jul 16, 2003
Messages
187
Office Version
  1. 365
Hey peeps,

On the main page/worksheet at the cell A3, I have a validation>list going. In that list I have city names. Within that list I would like to choose a city name and with the selection of the city name I would like cells A5 to A10 to copy the stores that are on another sheet corresponding to the city store names.

For example I select Calgary, in the validation list and the cell A5 would copy the store number that's on the cell B3 on the Calgary worksheet. Then A6 copies B4 and so forth.

From here I don't know what to use, I've tried IF but there's no logical test. Vlookup isn't right so I'm stumped. Either that or I'm not using the commands right.


All your help is appreciated.
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Hey smitty,

Unfortunately this doesn't help.... I usually get an e-mail asking for 5 out of the 10 stores. So in my second worksheet I want to select the 5 out of the 10 stores and have the 5 I selected to copy onto the original page from the validation selection on the first worksheet by selecting the city.
 
Upvote 0

Forum statistics

Threads
1,214,714
Messages
6,121,048
Members
449,007
Latest member
cloamp

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