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