VLOOKUP- concatenate 2 cells

  • Thread starter Thread starter lunker55
  • Start date Start date
L

lunker55

I have the formula: =VLOOKUP((A3&B3&C3),named!$G$77:$J$190,3,0)

In this cell, I would like the result to be column 3 and 4 concatenated, not
just column 3.
Can I modify this formula or do I need to create another column with the
cells concatenated?

Joe
 
Hi lunker55!

Try:

=VLOOKUP((A3&B3&C3),named!$G$77:$J$190,3,0)&VLOOKUP((A3&B3&C3),named!$
G$77:$J$190,4,0)


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Thanks Norman. Works perfectly!

Joe


Norman Harker said:
Hi lunker55!

Try:

=VLOOKUP((A3&B3&C3),named!$G$77:$J$190,3,0)&VLOOKUP((A3&B3&C3),named!$
G$77:$J$190,4,0)


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Click to expand...
 
Hi lunker55!

Thanks for thanks and confirmation.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top