| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Hybrid Mode
