Need Address Formula
 

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

If the desired name is in A1, then use VLOOKUP in A2 and A3 to get the
information from you table in cols {R,S,T}
--
Gary's Student


"Gary" wrote:

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

If you have your column R in alphbetical order, then place these two formulas
in the cells beneath theA1
bt the way the R1:T3 in the formula may need to be expanded since it only
represents 9 cells.

FORMULA IN A2 =VLOOKUP(A1,R1:T3,2,FALSE)

FORMULA IN A3 =VLOOKUP(A1,R1:T3,3,FALSE)



"Gary" wrote:

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