VLOOKUP- concatenate 2 cells

[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

 

[Norman Harker]

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.

 

[lunker55]

Thanks Norman. Works perfectly!

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.

 

[Norman Harker]

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.