Results 1 to 4 of 4

Provide output of Multiple criteria match

Threaded View

mromano Provide output of Multiple... 03-31-2011, 07:51 AM
NBVC Re: Provide output of... 03-31-2011, 08:29 AM
Leith Ross Re: Provide output of... 03-31-2011, 08:35 PM
mromano Re: Provide output of... 03-31-2011, 11:40 PM
  1. #1
    Registered User
    Join Date
    03-29-2011
    Location
    Trieste, Italy
    MS-Off Ver
    Excel 2019
    Posts
    12

    Provide output of Multiple criteria match

    Hi,
    I used the formula " =NOT(ISERROR(MATCH(B4;D4;0)))" to test the match between just two variables.
    Now, I would need to get a statement by using multiple match horizontal critera.
    I was lost while testing HLOOKUP nests:

    1) variable "up/down" in Column B (B4) must match with variable "up/down" in Column D (D4);
    2) if the result of (1) is FALSE, then print "FALSE" in Column E;
    3) if the result of (1) is TRUE, then match with variable "up/down" in Column C (C4)
    4) if C4 is the opposite of B4 and D4, then print "TRUE" in Column E4
    5) if C4 = B4 = D4, then print "FALSE" in E4

    Thank you very much for any suggestion

    PS: I now attach the file. sorry & Tx!

    -------------
    Ideal output;;;;;
    Reference LIST;Condition A;Condition B;Condition C;A = C * B
    ENSG0000013;down;down;down;FALSE
    ENSG00000083;up;up;--;FALSE
    ENSG00000147;down;down;down;FALSE
    ENSG000001076;up;--;--;FALSE
    ENSG0000014;down;--;down;MAYBE
    ENSG0000011711;down;down;down;FALSE
    ENSG000001840;down;up;down;TRUE
    ENSG0000018298;up;up;up;FALSE
    ;;;;;;;;
    Good output;;;;
    Reference LIST;Condition A;Condition B;Condition C;A = C * B
    ENSG0000013;down;down;down;FALSE
    ENSG00000083;up;up;--;FALSE
    ENSG00000147;down;down;down;FALSE
    ENSG000001076;up;--;--;FALSE
    ENSG0000014;down;--;down;TRUE
    ENSG0000011711;down;down;down;FALSE
    ENSG000001840;down;up;down;TRUE
    ENSG0000018298;up;up;up;FALSE
    Attached Files Attached Files
    Last edited by mromano; 03-31-2011 at 11:48 PM.

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