Inserting Multiple Cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am looking for a formula to bring in a row of text to a main table, from other pages. I have tables on multiple pages with name, task, Date. I need the formula to look for a persons name and bring in the rest of the information in that row and put it into a chart on the main page. I have tried Vlookup and cannot get multiple cells. Is there an easy way of doing this
 
Select a larger range when you enter the formula, assume you get the info
from Sheet2!A1:E50 like one value would be

=VLOOKUP(A1,'Sheet2'!A1:E50,2,0) will return one value from B if there is a
match, now instead do this
instead of putting the formula in let's say B2 and press enter, first select
B2:E2, then use a formula like

=VLOOKUP(A1,'Sheet2'!A1:E50,{2,3,4,5},0)

put the formula in the formula bar and enter it with ctrl + shift & enter,
it will put 2 { } around the formula if you did it correctly..

--

Regards,

Peo Sjoblom


Heather said:
I am looking for a formula to bring in a row of text to a main table, from
Click to expand...
other pages. I have tables on multiple pages with name, task, Date. I need
the formula to look for a persons name and bring in the rest of the
information in that row and put it into a chart on the main page. I have
tried Vlookup and cannot get multiple cells. Is there an easy way of doing
this?
 
Thanks for the help, it worked on a simplified sheet. My problem now is that I am not able to bring in multiple words that are in a cell. Is this possible

----- Peo Sjoblom wrote: ----

Select a larger range when you enter the formula, assume you get the inf
from Sheet2!A1:E50 like one value would b

=VLOOKUP(A1,'Sheet2'!A1:E50,2,0) will return one value from B if there is
match, now instead do thi
instead of putting the formula in let's say B2 and press enter, first selec
B2:E2, then use a formula lik

=VLOOKUP(A1,'Sheet2'!A1:E50,{2,3,4,5},0

put the formula in the formula bar and enter it with ctrl + shift & enter
it will put 2 { } around the formula if you did it correctly.

--

Regards

Peo Sjoblo


Heather said:
I am looking for a formula to bring in a row of text to a main table, fro
Click to expand...
other pages. I have tables on multiple pages with name, task, Date. I nee
the formula to look for a persons name and bring in the rest of th
information in that row and put it into a chart on the main page. I hav
tried Vlookup and cannot get multiple cells. Is there an easy way of doin
this
 
Back
Top