Posts by md01

    My challenge is pulling in a data element from a file to an exisiting file based on two criteria.
    give me the value in cell e1 if cell b1 matches AND

    File 1
    A B C
    1 H12377 03/05/2013 123
    2 H12377 03/27/2013 276
    3 H32389 05/03/2013 335

    File 2
    H12377 03/27/2013 _________

    how do I get C2 value from file 1 (276) into file2 since column A is not unique but column A plus Column B is unique?