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

Advertisements

D

Domenic

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

Hope this helps!
 
Ad

Advertisements

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
vlookup formatting problem 1
VLOOKUP Function and data combined from 2 cells 2
VLOOKUP 2
Vlookup where table array is in text format 4
vlookup 3 sheets 1
How do I insert a dynamic reference of a range inside VLOOKUP? 4

Top