Auto fill an address

  • Thread starter Thread starter Ahmed55
  • Start date Start date
A

Ahmed55

I have a Purchase form for our company that is locked and we can't open it to
edit. So we are trying to recreate it.

One of the features was that when someone would select the "Location" the
"Ship to" address would automatically fill in the rows beneath the "Location"
selection dropdown.

Can someone give me advice on how to execute this? Probably something like;
if B4=Main Office, then T3....etc

Thanks
 
Ahmed,

Create a table of location names and addresses, with as many data fields as your might need (like
address, City, State, Zip - or just an address string).

Then use a formula like

=VLOOKUP(LocationCell,Table,2,False)

in the cell where you want the address.

HTH,
Bernie
MS Excel MVP
 

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

Auto Poputating Address in Word 2003 1
Can Validation against a list do auto-fill in a cell? 5
Drop List Valadation and Auto Fill 3
Auto Fill Cells 3
Auto fill-in text and importing information 1
Autofill cell/sets of cells based upon value selected from a list. 1
Auto filling of form letters 2
Auto-fill from Validation List 2

Back
Top