Fill a cell by selecting a value from a list

Y

yasser

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
 
U

ufo_pilot

=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.
 
Top