+ Reply to Thread
Results 1 to 3 of 3

Vlookup question

  1. #1
    Registered User
    Join Date
    01-11-2011
    Location
    Boston, US
    MS-Off Ver
    Excel 2003
    Posts
    8

    Vlookup question

    Hi, all,

    I need help!

    I have Table1 and Table2 in Spreadsheet. In Table2, there are two or more Invoice Number under same Serial Number.
    What I wnat is display the Invoice Number as Original Invoice Number in Table1 if Invoice Number in Table2 is different than Invoice Number in Table1 under same Serial Number.
    I tried using Vlookup, but it just display the first value found.

    Sample data is attached.

    Please advise.
    Attached Files Attached Files
    Last edited by slin; 01-11-2011 at 09:42 PM.

  2. #2
    Registered User
    Join Date
    01-09-2011
    Location
    Gabrieola
    MS-Off Ver
    2003,2007
    Posts
    32

    Re: Vlookup question

    Check the progress of this thread,
    http://www.excelforum.com/excel-gene...l-results.html

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2013
    Posts
    8,623

    Re: Vlookup question

    Hi slin,
    Try in M1 this formula
    copy to clipboard
    Please Login or Register  to view this content.
    and copy down
    See attached
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * below to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts