|
how to use vlookup for more than 1line
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. |
how to use vlookup for more than 1line
Tell us more about the table of data and the formula you are using to
extract info best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "LHM" wrote in message ... 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. |
how to use vlookup for more than 1line
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 "Bernard Liengme" wrote: Tell us more about the table of data and the formula you are using to extract info best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "LHM" wrote in message ... 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. |
how to use vlookup for more than 1line
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 "JCS" wrote: 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 "Bernard Liengme" wrote: Tell us more about the table of data and the formula you are using to extract info best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "LHM" wrote in message ... 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. |
| All times are GMT +1. The time now is 04:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com