VLOOKUP question

Hi
Can vlookup return more than 1 column?

If not how could I return more than 1 column?

hopefully
Tom

vlookup generally returns a single cell value;
provide more specifics of what you have and want, please...



"Tom Weston" <t.m.weston@dl.ac.uk> wrote in message
news:dsi2j8$he4$1@blackmamba.itd.rl.ac.uk...
> Hi
> Can vlookup return more than 1 column?
>
> If not how could I return more than 1 column?
>
> hopefully
> Tom
>
>

Hi Tom,

Give this a try to return three columns. Will work with more than three,
don't know the limit, if any.

Select three cells in a row. While selected, type in this formula and array
enter, CTR + SHIFT + ENTER.

=VLOOKUP(F1,A1:D5,{2,3,4},)

Returns column 2, 3 and 4 of the Table Array A1:D5. If you make changes to
the formula you will need to select all three cells that have the formula in
them, and array enter when exiting after changes.

If you want all the returns in one cell something like this perhaps.

=VLOOKUP(F1,A1:D5,2,0)&VLOOKUP(F1,A1:D5,3,0)&VLOOKUP(F1,A1:D5,4,0)

HTH
Regards,
Howard

"Tom Weston" <t.m.weston@dl.ac.uk> wrote in message
news:dsi2j8$he4$1@blackmamba.itd.rl.ac.uk...
> Hi
> Can vlookup return more than 1 column?
>
> If not how could I return more than 1 column?
>
> hopefully
> Tom
>
>