how to use vlookup for more than 1line

[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.

 

[Bernard Liengme]

Tell us more about the table of data and the formula you are using to
extract info
best wishes

 

[JCS]

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

 

[LHM]

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