Thank short cut on the filing the arrays out is great.
Do you have any suggestion for speed that would run better that
if(isna('vlookup forumula","vlookup formula")
When I add this to take away the #n/a's it
kills the speed

"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