I am trying to have a single point on a worksheet that has 3 cells (name(A1)
then street address(A2) and city, state, zip(A3). I have a place in the
worksheet that has the names listed in column (R) Street Addresses in column
(S) and City, State, Zip in column(T). I want when I enter a name in
A1...excel places the street address in cell A2 and the city,state, and zip
in A3...can anyone please help me with this...I am about to pull my hair
out...haha...thanks in advance...