Combining 2 VLOOKUP Formulas

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

Domenic

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

Hope this helps!
 
P

Patti

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)
 

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

Need VLOOKUP to Work Two Ways 0
Searching the formula (not the value) for a text string 1
Wrong Result with an IF function 6
Nested Formulas v Named Formulas Any other solutions? 10
Combining an IF with another formula 4
Combining IF Statement and Vlookup 0
Vlookup if 0 then POA 5
Vlookup and If statement help 1

Top