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

"vickyb_au" wrote in message
...
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?????