Using a lookup to return multiple values in one cell??

Ok, basically I want to do a lookup to return some figures...  I know
all the VLOOKUP, etc...  trouble is I don't just want to return one
figure.  It may be 1 figure but then it may be about 9/10 as well.


I've got a list of order numbers and a list of orders that need an
invoice date next to them.  So I've done a bog standard vlookup and it
only returns one figure where as there might be 10 invoices related to
1 order...  make any sense  :?


(Table 1)

Order Number................... Invoice Date

10010001....................... 22/11/05
10010001....................... 14/10/05
10010002....................... 25/09/05
10010002....................... 21/12/05
10010002....................... 23/11/05
10010002....................... 05/10/05
10010002....................... 15/11/05
10010003....................... 20/12/05
etc...


(Table 2)

Order Number....  Supplier.... Invoice Date

10010001........  xxxxxxxx.... *lookup from table 1*
10010002........  xxxxxxxx.... *lookup from table 1*
10010003........  xxxxxxxx.... *lookup from table 1*

0
7/7/2006 9:10:43 AM
excel.newusers 15348 articles. 2 followers. Follow

1 Replies
392 Views

Similar Articles

[PageSpeed] 53

Hi Zim,

Use Data>Filter>Autofilter instead

HTH
--
AP

"zim_zimmer" <paul_mittoo@hotmail.com> a �crit dans le message de news: 
1152263442.387091.138770@m79g2000cwm.googlegroups.com...
> Ok, basically I want to do a lookup to return some figures...  I know
> all the VLOOKUP, etc...  trouble is I don't just want to return one
> figure.  It may be 1 figure but then it may be about 9/10 as well.
>
>
> I've got a list of order numbers and a list of orders that need an
> invoice date next to them.  So I've done a bog standard vlookup and it
> only returns one figure where as there might be 10 invoices related to
> 1 order...  make any sense  :?
>
>
> (Table 1)
>
> Order Number................... Invoice Date
>
> 10010001....................... 22/11/05
> 10010001....................... 14/10/05
> 10010002....................... 25/09/05
> 10010002....................... 21/12/05
> 10010002....................... 23/11/05
> 10010002....................... 05/10/05
> 10010002....................... 15/11/05
> 10010003....................... 20/12/05
> etc...
>
>
> (Table 2)
>
> Order Number....  Supplier.... Invoice Date
>
> 10010001........  xxxxxxxx.... *lookup from table 1*
> 10010002........  xxxxxxxx.... *lookup from table 1*
> 10010003........  xxxxxxxx.... *lookup from table 1*
> 


0
ardus.petus (319)
7/7/2006 9:28:33 AM
Reply:

Similar Artilces:

txt search box returns all records when wildcard is entered
I have used a simple textbox search originally created by Graham Thorpe [Event Procedure]. When I open my search form If I type in and abbreviated search text for example 206 vs. 206-030-987-101 It returns all of the records in the database. If I search on 206-030-987-101 it will find that specific record and display it, but all records are available. I would like help with using the textbox search to bring up only those records containing the exact match if one is available and not physically being able to view any other records in the current form. I would like to also be able to pe...

Anyone currnetly using a deposit deadline calender?
...

lookup in one sheet and insert in second if not found
I have created a workbook with two sheets in it. I enter all my order in sheet one and the sheet two totals them. The column on my sheets ar as follow�. Sheet one STYLE SMALL MEDIUM LARGE 100 1 1 1 101 1 1 1 100 1 1 1 102 Sheet two STYLE SMALL MEDIUM LARGE 100 2 2 2 101 1 1 1 I have used the SUMIF command in the second sheet, which is correct Therefore my totals are correct. The only problem I am having is thi ��.that I have to enter the style numbers in the second sheet as well. What I want to do is, to have some kind...

How in Email Newsletter to use Hyperlinks, Bookmarks and Coded HTM
I am trying to include bookmarks in a Publisher email newsletter, and I have learned how to do this with creating a Web page, but I have had no success with email newsletters. I would like to add a "Return to Top"-type link in my newsletter which redirects the reader to the top of the same page. Not in a Web site, but in an email newsletter. Any suggestions? Thanks! Start with an email formatted newsletter. Convert to webpage. Using the Insert html code fragment tool, copy and paste (Ctrl V) the following code snippet: <A HREF="#TOP">Top of Page</A> ...

Fix #VALUE! error
I need a fix to a simple formula where a cell is not being recongized. example below: cell C1 has 88 in it with no visible formula cell E1 - I put in formula =product(C1,2080) returned 2080 as the solution but should have been 183040 "Charles" <Charles@discussions.microsoft.com> wrote in message news:E3567F0A-328A-4E66-8729-9B1A44CD30CE@microsoft.com... > I need a fix to a simple formula where a cell is not being recongized. > example below: > cell C1 has 88 in it with no visible formula > cell E1 - I put in formula =product(C1,2080) > returned 2...

get and put value
How do I get the value some colomn before (and after) ActiveCell.Value and put in a cell ex : A1 = "UK" B1 = "US" C1 = "AU" D1 = "ID" E1 = "DE" The activecell is C1, I want to get the value of colomn A,B,D,E and put in (let say) AA,BB,DD,EE thx VBA? Range("AA1").Value = Cells(Activecell.Row,"A").Value etc. -- HTH Bob Phillips "!..:: Enang ::..!" <ndoel@pintumas.co.id> wrote in message news:u6Gi7qCwFHA.460@TK2MSFTNGP15.phx.gbl... > How do I get the value some colomn before (and after) ActiveCel...

portfolio value vs cost basis
In Money (2003 or higher), is there any way to generate a portfolio cost basis vs value graph over a certain period of time? TIA Su. On 2005-05-16, Su Bapat <subapat@hotmail.com> wrote: > In Money (2003 or higher), is there any way to generate a portfolio cost > basis vs value graph over a certain period of time? I don't think so. But I sure would like that graph. ...

See if cell is in Range
Thanks for taking the time to read my question. I'm passing a string that is a cell reference to a function. In that function I want to determine if that cell reference is within a predetermined range. Not sure how to do that. Right now I have: Function CheckRange(TheSheet As String, TheCell As Range) As Boolean If TheSheet = "Sheet1" Then if TheCell In Range("B4:B30") then 'This line is red as it is incorrect CheckRange = True End If What do I use instead of "In"? Thanks, Brad Brad Use something like: If In...

Editing in a cell
I am having a problem with a newly created workbook. When I go to a cell that has data in it and try to add more data to the existing string I lose all the previous information. The work sheet that I am working in is protected and I have "edit directly in cell" checked in the options section. It is almost like my double click (as well as F2) are being treated as a single click. Thank you I figured it out. For some reason "Hide" is selected for the unlocked cells. "John English" wrote: > I am having a problem with a newly created workbook. > > Wh...

Primission / resticted access to files using the MS server
I wish I have NEVER deciced to use this facility!!!@ I should have kept to paper and pin.. This word file is totally useless to me now. I have been using the tool facilty sucessfully for years but now it won't let me get to my own files.., I think you can tell what I think about this product. Hello Ron Ron wrote: > I wish I have NEVER deciced to use this facility!!!@ I should have kept to > paper and pin.. This word file is totally useless to me now. I have been > using the tool facilty sucessfully for years but now it won't let me get to > my own fi...

Money signs appear in my Cell and I don't want them there
Im trying to enter the numbers 2.9 in cell like AD and it turns it into $2.90. That is not what I need, how do I stop that? Format as General instead of currency -- Regards, Peo Sjoblom http://nwexcelsolutions.com "kate" <kate@discussions.microsoft.com> wrote in message news:E9EEA936-437C-486F-A2D3-2385EF6BD2D0@microsoft.com... > Im trying to enter the numbers 2.9 in cell like AD and it turns it into > $2.90. That is not what I need, how do I stop that? ...

How do I get a cell to remember the last entry and add to it?
I am using Excel 2000. I want my cell to remember the number in it and add an additional number each time I need to retotal. Jab Sounds like you want that cell to be an accumlator cell. Simple question with complex results. You can have a cumulative total in a cell if you have a separate source cell for adding a new total to the original. Use at your own risk. I am Posting this just to show you how it can be done, not as a good solution. You would be much better off to have another column so you can keep track of past entries. Goes like this: =IF(CELL("address")="$C$4&...

Printing only rows with value in certain column
Does anyone know a way that I can print only rows that have a value in a certain column? I have a large spreadsheet that I print often and would like to be able to print only the rows with a value in column M. --- Message posted from http://www.ExcelForum.com/ Hi see: http://www.rondebruin.nl/print.htm#Hide -- Regards Frank Kabel Frankfurt, Germany "willmain >" <<willmain.1buqpn@excelforum-nospam.com> schrieb im Newsbeitrag news:willmain.1buqpn@excelforum-nospam.com... > Does anyone know a way that I can print only rows that have a value in a > certain column?...

How to limit subform to one record?
I have certain instances where I need a subform to be able to accept one record, and no more. I've been trying setting allowadditions to false if dcount (records for that mainform record) >0, but I can't get the setup right in terms of which event to trigger it, etc. Any advice? On Wed, 30 Jan 2008 13:41:00 -0800, markmarko <markmarko@discussions.microsoft.com> wrote: >I have certain instances where I need a subform to be able to accept one >record, and no more. > >I've been trying setting allowadditions to false if dcount (records for that >mainf...

Visio is unable to create a shape using this master shortcut.
I want to use a shape called 1-D Word balloon so I try to drag it from Charting Shapes to my work but I get the following message: Visio is unable to create a shape using this master shortcut. The target master cannot be found in the target document Dragging basic shapes works fine. I'm using Visio 2003. Thank you. On Thu, 9 Apr 2009 11:53:01 -0700, Pierre <idontwanttoreceiveemail@hotmaildotcomm> wrote: >I want to use a shape called 1-D Word balloon so I try to drag it from >Charting Shapes to my work but I get the following message: > >Visio is unable to creat...

Sort Problem using a button
I have several worksheets, that I need to sort. My idea was to put a button on what I call my 'input page' and sort each of these pages. But I get the error: "Run-Time Error 1004: The sort reference is not valid. Make sure that it's within the data you want to sort, and the first Sort by Box isn't the same or blank." Now on sheet 1 is where the button is. Information that is to be sorted is on sheet2, sheet3 sheet 4 and etc. Sort code is: Private Sub Sort1() ActiveSheet.Range("A2:D14").Select Selection.Sort Key1:=Range("A2&quo...

Using Excell to input data into Access
Is it posible to use an excel spreadsheet to enter data into access? The actual reason for using excel to enter the fields in access is that over 100 of our users are familiar with excel, but do not know anything about databases. They actually call excel a database about 1/2 of the time. We work in a contract research facility that does lots of different projects in several scientific disciplines of varying complexity. I started using databases to store my research data in back in the 80's with db3. We did not even have an IT department until about 2 years ago. I have been trying to drag ...

Useful website
This is a multi-part message in MIME format. ------=_NextPart_000_00FA_01C37D48.8D545F20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable just have a look on my website. http://earnmoneytoday.0catch.com Thank you ------=_NextPart_000_00FA_01C37D48.8D545F20 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859...

Average using Sumproduct or ....
I have 12 tabs (same worksheet) that I need to average a number in cell b6. The issue is sometimes there is a zero in b6 and I do not want to count it in the average. example: tab 1, b6=145, tab 2=276, tab 3=0, tab 4= 123, tab 5=0, and so on... What is a good formula? Try =SUMPRODUCT(SUMIF(INDIRECT("'Sheet"&ROW(INDIRECT("1:12"))&"'!B6"),"<>0")) /SUMPRODUCT(COUNTIF(INDIRECT("'Sheet"&ROW(INDIRECT("1:12"))&"'!B6"),"<>0 -- HTH Bob "heater" <...

creating workflow using MS Outlook
hi! can anyone help me on how to develop a leave workflow app using outlook. ...

How to copy (or move) Journals from one folder to another
Yesterday I had to rebuild my Outlook file, and I have a working version now but all my journals are in a 2nd folder rather than in the main Journal one. As I can't delete the empty main one, ideally I'd like to move the entrieds from the second one to the main folder. Is this possible? I tried exporting them to a pst file and importing them but either it didn't work or I did it wrong. Any help gratefully recieved rdc You did it wrong - NEVER use the import/export option to move native = Outlook data. Having already done so, you now have a corrupt profile. Create a ne...

Excel opens two worksheets instead of one
I have Office 2007 and recently upgraded to Windows 7. When I open an existing document in Excel, sometimes (about 50% of the time) it opens a second blank worksheet along with it. Word does this also. Is there a way to fix this? -- Thank you ...

Correlation
I have a table of data as below. There are more Customers, and more dates' worth of data, but they won't fit in this window. For a number of our customers, we change delivery routes during the week in order to optimize our shipping capacity. Basically, I am trying to see for each delivery route, on a given day, how many of the same customers are on the same route. In other words, when one customer changes from one route to another over a date range, do other customers switch to the same routes on the same days? Cust # Rt# 8/27/2005 8/29/2005 8/30/2005 8/31/2005 a 1069 ...

Reading one Record at a time till i reach EOF in VC++ using ODBC
Hi, i am working on Vc++6.0. I hve a req where in i need to read one record at a time till i reach EOF from the database.Can anyone tell me how to do this Very urgent Thanks Use CDatabase and CRecordSet classes. // Embed a CDatabase object // in your document class CDatabase m_dbCust; // Connect the object to a // read-only data source where // the ODBC connection dialog box // will always remain hidden m_dbCust.OpenEx( _T( "DSN=MYDATASOURCE;UID=JOES" ), CDatabase::openReadOnly | CDatabase::noOdbcDialog ); CRecordSet rs;rs.m_pDatabase=&m_db...

Help Freezing Multiple Rows
In earlier versions, you clicked below the rows you wanted frozen in place or to the right of the rows you wanted frozen. Now I see only how to freeze row 1. I have a main title in row 1, row 2 is blank and row 3 has column headings, so I want row 3 to stay frozen in place. I am having trouble accomplishing this and need help, please. Thank you. -- Virgo click on cell A4 then on the menu bar Window/Freeze Panes "Virgo" wrote: > In earlier versions, you clicked below the rows you wanted frozen in place or > to the right of the rows you wanted frozen....