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
A B C
1 H12377 03/05/2013 123
2 H12377 03/27/2013 276
3 H32389 05/03/2013 335
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?