 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2006Vlookup multiple
We have invoices by company name how can we select all the invoices with 1 vlookup ex:row a1 A10 A13 A17 all are for (john) all of them are for for the same customer we want to have several lines on invoice for each invoice automatically filled itemized with vlookup, or what is if we need only invoice from a10? auto filter or sort  Signaturepaul paul.shepherd@nospamparadise.net.nz remove nospam for email addy! > We have invoices by company name how can we select all the invoices with 1 > vlookup ex:row a1 A10 A13 A17 all are for (john) > all of them are for for the same customer we want to have several lines on > invoice for each invoice automatically filled itemized with vlookup, or what > is if we need only invoice from a10? Hi I would use Advanced Filter to extract the lines required for that customer to a second Sheet, then print out that sheet as the invoice. Take a look at Debra Dalgleish's site for help on how to do this. There are some sample files you can download to help you as well. http://www.contextures.com/xladvfilter01.html#ExtractWs SignatureRegards Roger Govier > We have invoices by company name how can we select all the invoices > with 1 [quoted text clipped - 4 lines] > or what > is if we need only invoice from a10? Does this mean we can not use the vlookup to fill all data, we have to design a sheet without the vlookup? > We have invoices by company name how can we select all the invoices with 1 > vlookup ex:row a1 A10 A13 A17 all are for (john) > all of them are for for the same customer we want to have several lines on > invoice for each invoice automatically filled itemized with vlookup, or what > is if we need only invoice from a10? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.