+ Reply to Thread
Results 1 to 9 of 9

Text results with two conditions (lookup with two conditions)

  1. #1
    Registered User
    Join Date
    05-25-2012
    Location
    Drnis, Croatia
    MS-Off Ver
    Excel 2010
    Posts
    31

    Text results with two conditions (lookup with two conditions)

    Hello everyone, I'm new to the forum so please don't be to harsh

    Here is my question, is there a way to get 2 conditions in lookup formula, I tried a lot of stuff, INDEX/MATCH array formula, vlookup, IF and few more i can't even remember now. Since i'm not a native english speaker i will put a table here so it
    might be easier to understand.

    What i would like to be done automatically is: in sheet2 C2 copy a name of engineer from Sheet1, if date and shift are the same on Sheet1 and Sheet2.

    Any ideas?
    Attached Files Attached Files

  2. #2
    Forum Expert icestationzbra's Avatar
    Join Date
    01-07-2004
    MS-Off Ver
    2007, 2010
    Posts
    1,417

    Re: Text results with two conditions (lookup with two conditions)

    Sheet2 cell C2:
    Please Login or Register  to view this content.
    drag-fill down.
    - i.s.z -
    CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
    Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
    All good ideas are courtesy resources from this forum as well as others around the web.
    - e.o.m -

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

    Re: Text results with two conditions (lookup with two conditions)

    Welcome.
    or lookup

    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

  4. #4
    Registered User
    Join Date
    05-25-2012
    Location
    Drnis, Croatia
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: Text results with two conditions (lookup with two conditions)

    Thanks for the quick answers but I can't get it to work, is there a chance that cell format is interfering with formulas?

  5. #5
    Forum Expert icestationzbra's Avatar
    Join Date
    01-07-2004
    MS-Off Ver
    2007, 2010
    Posts
    1,417

    Re: Text results with two conditions (lookup with two conditions)

    i tested my formula on the sample file you have uploaded. aren't your real data like the data in your sample? what are the data cells formatted as?

    if your real data / format is different, can you upload a snapshot of that?

  6. #6
    Registered User
    Join Date
    05-25-2012
    Location
    Drnis, Croatia
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: Text results with two conditions (lookup with two conditions)

    Sample has the same format of those columns that are in, original file has more info but it should't be connected in any way. And the weird thing is i cant' get your formula to work on sample i uploaded. Can it be because of Excel 2010?

    It's highlighting this part of formula $D$21,MATCH
    Last edited by Davzx; 05-25-2012 at 02:43 AM.

  7. #7
    Forum Expert icestationzbra's Avatar
    Join Date
    01-07-2004
    MS-Off Ver
    2007, 2010
    Posts
    1,417

    Re: Text results with two conditions (lookup with two conditions)

    see attached.

    i have inserted my formula as well as vlady's, to show that both work just fine on your sample file.

    it should not have anything to do with Excel 2010, which is a higher version than the one i am using. if it were the other way around, i would have been suspicious.
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    05-25-2012
    Location
    Drnis, Croatia
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: Text results with two conditions (lookup with two conditions)

    This is what i got when i opened it =INDEX(Sheet1!$D$2:$D$21;MATCH(Sheet2!$A2&Sheet2!$B2;INDEX(Sheet1!$A$2:$A$21&Sheet1!$C$2:$C$21;0);0)) and now it works. Should've known that i need to replace , with ;
    Sorry for the confusion, i'm still new to excel.

    Anyways... thanks guys, you saved me a lot of time.

  9. #9
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,405

    Re: Text results with two conditions (lookup with two conditions)

    Yes, we use ; in our Regional settings.
    Just change , to ; wherever you see it

+ 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