+ Reply to Thread
Results 1 to 4 of 4

Lookup value and match with 2 criteria and return another value

  1. #1
    Registered User
    Join Date
    11-28-2012
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel H&B 2013
    Posts
    14

    Lookup value and match with 2 criteria and return another value

    Hi All,
    I would like to do a Lookup and match with 2 critera and return a third value.
    On my sheet 'DATA' in cell "C2" I would like to lookup and match the order no "O/N" & 'INVTOTAL" and find the "INV No" on sheet 2.

    Sheet1 "DATA" contains;
    O/N INVTOTAL INV No SUPERVISOR POSITION EMPLOYEE INV DATE TOTAL
    U11888 1759.62 ? MERV MAHER LEVEL 9 WEBSTER Joshua 1st JUL 2009 284.75

    Sheet 2 "INVOICES" contains;
    O/N INV TOTAL INV No DATE NET GST DIV SUPERVISOR
    U11888 1759.62 63008 1/07/2009 1599.65 159.97 BURLEIGH MERV MAHER

    Your help is much apreciated.
    Craig
    Attached Files Attached Files

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Lookup value and match with 2 criteria and return another value

    try

    array formula ->ctrl+shift+enter not just enter

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  3. #3
    Registered User
    Join Date
    11-28-2012
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel H&B 2013
    Posts
    14

    Re: Lookup value and match with 2 criteria and return another value

    Thank you Vlady that did the job.
    Sorry I didn't reply yesterday I was called away.
    Thanks again.

    Craig

  4. #4
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Lookup value and match with 2 criteria and return another value

    Your welcome. Thank you also.
    Regards,
    Vladimir

+ 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1