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