vlookup and mutli column pops
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
|