returning more columns with vlookup?

[eglea]

Hi all

by default vlookup returns 1 column. Is there a way to return more than
1 (not necessarily adjacent) columns?

example

instead of

=VLOOKUP(38, A2:L10, 3, FALSE)

using something like

=VLOOKUP(38, A2:L10, (3,7,9), FALSE)

that would return cells in columns 3, 7 and 9 ?

Thanks!

 

[Niek Otten]

Maybe not exactly what you require, but it might help you:

http://www.cpearson.com/excel/TablesAndLookups.aspx

Look under the heading "Returning A Row Or Column From A Table"

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi all
|
| by default vlookup returns 1 column. Is there a way to return more than
| 1 (not necessarily adjacent) columns?
|
| example
|
| instead of
|
| =VLOOKUP(38, A2:L10, 3, FALSE)
|
| using something like
|
| =VLOOKUP(38, A2:L10, (3,7,9), FALSE)
|
| that would return cells in columns 3, 7 and 9 ?
|
| Thanks!