Excel Function to Match Data
Posted on 2015-02-18
I am going to have text data in column A, a date in column B and a count in column C that represent 'before' values. In columns E, F anf G, I am going to have 'after' values. There might be more after rows (won't be less), and the counts might not be the same as the before values.
Ideally, I'd like to code a function that I can replicate down column H. I want to match columns E and F against columns A and B. If I get a match, then I want to compare the values in C and G. If they don't match, then I want to display something in column H (e.g. "!="). If I cannot match E and F against A and B, then I want to display some other character in column H (e.g. "**").