Look up

  • Thread starter Thread starter Jill
  • Start date Start date
J

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!
 
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
 
Use filters to do things like that.. You can just filter and then copy over
or automate it through VBA
 
Back
Top