returning more columns with vlookup?

  • Thread starter Thread starter eglea
  • Start date Start date
E

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!
 
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!
 
Hi eflea,

Try this. If you are going to return 5 columns, select five cells in a row
and while selected enter this formula. The formula will only be in the left
most cell to start with.

=VLOOKUP(A1,B1:K15,{2,4,6,8,10},0)

Now hit Ctrl + Shift + Enter.

Looks up the value in A1 and returns five column (of your choice) in the
cells selected. If you modify the formula you must select all cells that
have the formula and make the changes and Array Enter again.
(Ctrl+Shift+Enter)

HTH
Regards,
Howard
 
Back
Top