Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
Can vlookup return more than 1 column? If not how could I return more than 1 column? hopefully Tom |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
vlookup generally returns a single cell value;
provide more specifics of what you have and want, please... "Tom Weston" wrote in message ... Hi Can vlookup return more than 1 column? If not how could I return more than 1 column? hopefully Tom |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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)&VLOOK UP(F1,A1:D5,4,0) HTH Regards, Howard "Tom Weston" wrote in message ... Hi Can vlookup return more than 1 column? If not how could I return more than 1 column? hopefully Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
vlookup question | Excel Worksheet Functions | |||
VLOOKUP() Question... i hope | Excel Discussion (Misc queries) | |||
Vlookup question please | Excel Worksheet Functions | |||
vlookup question please | Excel Worksheet Functions | |||
Vlookup against multiple columns/worksheets question | Excel Discussion (Misc queries) |