No, I think that is bad info. To get two results returned to the same cell,
you'd need to concatenate two VLOOKUPs together. Like this:

=VLOOKUP(G5,Sheet1!$A$1:$J$50000,3,FALSE) &
VLOOKUP(G5,Sheet1!$A$1:$J$50000,4,FALSE)

HTH
Elkar


"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