how to use vlookup for more than 1line

  • Thread starter Thread starter LHM
  • Start date Start date
L

LHM

I have severeal lines for every invoice number. Vlookup formula just bring
the first line. I need a formula to bring all lines to my summary sheet.
 
Tell us more about the table of data and the formula you are using to
extract info
best wishes
 
HI,

What you have here is a one-to-many relationship. This can easily be done
in Microsoft Access where one table is related to another table with many
relations. But if you need to do this in Excel, I agree with Bernard we need
more info about your tables and data setup.

John
 
There is invoice#1: which has
2lines in sheet1(subcontract1),
3 lines in sheet2 (subcontract2) and
2 lines in sheet3(subcontract3).

What I need, I want to bring all these lines to summary sheet.
Unfortunately it is the way it has been set up!

Thanks,
Leila
 
Back
Top