vlookup and mutli column pops
I do not understand
the {1,2,3,4}
will this take col ABCD in table array
and put them in the same cell
next
if I typed
{1, 2, 3, 4} would this put a space in the data
in the single cell
plesse advsie
"Gord Dibben" wrote:
No. You can't use that construction.
You might be thinking of something like this.
Select B1:E1
Type =VLOOKUP(A1,'Sheet1'!$A$1:$J$50000,{2,3,4,5},FALSE ) into B1 and
CTRL + SHIFT + ENTER to enter as an array formula.
You could combine two lookups in one cell with one formula.
=VLOOKUP(A1,'Sheet1'!$A$1:$J$50000,3,FALSE) & " " &
VLOOKUP(A1,'Sheet1'!$A$1:$J$50000,4,FALSE)
Gord Dibben MS Excel MVP
On Tue, 16 Dec 2008 17:28:00 -0800, Dylan @ UAFC
wrote:
trying an alternative to a major complex serious of
columns.
I was reading that in formulas you can have 2 column entryies
return int the same cell for exaple
=VLOOKUP(G5,Sheet1!$A$1:$J$50000,{3,4},FALSE)
In theory the would display the 3rd and forth column in one cell
but I cannot get it to work.
is some one giving me some bad info, or could
you have several columns in onecell
|