Combining 2 VLOOKUP Formulas

  • Thread starter Thread starter tim fogarty
  • Start date Start date
T

tim fogarty

How do you combine 2 vlookup formulas in one cell? I am
trying to add this formula:

(VLOOKUP($A$9,GeneralFirmInfo,3,FALSE))

and this formula:

(VLOOKUP($A$9,GeneralFirmInfo,4,FALSE)).

I am accessing text through these formulas. Specifically,
I am trying to combine City/State and Zip Code in one cell.

A simple '+' between the two formulas gives this message:
#VALUE!

Thank you.
 
=VLOOKUP($A$9,GeneralFirmInfo,3,FALSE)&"
"&VLOOKUP($A$9,GeneralFirmInfo,4,FALSE)

Hope this helps!
 
I think "&" will do it. Here's an example including a
comma and a space as delimiters.

=VLOOKUP($A$9,GeneralFirmInfo,3,FALSE)&", "&VLOOKUP
($A$9,GeneralFirmInfo,4,FALSE)
 
Back
Top