Fill a cell by selecting a value from a list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi!
Problem: I have a drop down list in Cell A1 which lists our 10 store
numbers. The user must select their store number and I want cell A2 to
Automatically fill in the Store's Address, instead of the User typing it
manually. (This is to avoid spelling errors because this cell is linked to a
table in Access)

Please tell me how I can solve this problem.

Thanks,

Yasser
 
=VLOOKUP($A$1,J1:L10,3,FALSE)
Use this
Lookup cell A1 ( name of store)
look in J1:L10( you will need to have a list, with all the store names --
here names would be in column J, something in column K ( maybe phone number)
and column L would have the address
it specifies to look in the 3rd column ( col L)
edit as you would need this to be.
perhaps you could have the addresses next to the names of the stores you
use in your drop down list.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically fill cell value 1
Automatically fill cells when selecting from a drop down list 3
Excel 2007 drop down lists 6
can a cell be both input and output? 2
Multiple lists and vlookup 2
Automatically fill info from a list 4
Clearing cells when selecting from a drop down list 1
Help! I want to fill cells as a result of selecting a value from a list in another cell. 6

Back
Top