Look up

[Jill]

Hi,

I want to bring back data from a number of sheets in an
excel file into a one pager summary sheet.

For example in cell 1A I have a name that has three
columns of corresponding data ie - telephone number,
address and hobby. For each name there is more than one
entry spanning over a number of rows.

When I use a VLOOKUP to bring the data into one page it
looks for the first entry beside the name you are
searching and brings that entry back. But I want it to
bring back the first entry and then the second, third etc.
and display them in different rows on the one pager.

Obviously VLOOKUP on its own is not sufficient to solve
this problem so I'm wondering if anyone has an alternative
solution for this problem.

Thanks!

 

[L. Howard Kittle]

Hi Jill,

Select 3 cells, (not including F1), and while selected, enter something like
this:

=VLOOKUP(F1,RANGE,{2,3,4},0)

Where F1 is where you enter the lookup name.
Where RANGE is the Table_Array. (Your names and tele no., & hobbies)
You will need to Array Enter this formula.
Ctrl + Shift + Enter

Should look like this when properly entered:

{=VLOOKUP(F1,RANGE,{2,3,4},0)}

If you make changes to the formula after it is entered you will need to
select all 3 cells and then make the change and do another Ctrl + Shift +
Enter.

HTH
Regards,
Howard

 

[Peo Sjoblom]

Use filters to do things like that.. You can just filter and then copy over
or automate it through VBA