return a range of cells from a vertical lookup

I would like to know if I can return a range of cells (up to 30 columns to
the right of the lookup) when using vertical lookup forula?????

To the best of my knowledge, VLOOKUP only returns one value.

"vickyb_au" <vickyb_au@discussions.microsoft.com> wrote in message
news:827417F1-7F16-4C9F-9491-A7D884AECF77@microsoft.com...
>I would like to know if I can return a range of cells (up to 30 columns to
> the right of the lookup) when using vertical lookup forula?????

use array VLOOKUP

the formula looks like :
=VLOOKUP([key],[find in range],{2,3,4,...,31},0)

suppose you the VLOOKUP result in A10:AD10. So select A10:AD10, type the
formula above, press Ctrl+Shift+ENTER.


"vickyb_au" wrote:

> I would like to know if I can return a range of cells (up to 30 columns to
> the right of the lookup) when using vertical lookup forula?????