I want to match data in Col A v/s Col B and display the exact match in Col C. How can I do that?
A aquaflow Jul 10, 2008 #1 I want to match data in Col A v/s Col B and display the exact match in Col C. How can I do that?
A aquaflow Jul 10, 2008 #3 In C1, =IF(A1=B1,"match","no match") and copy down. Click to expand... I want to match same values in Col A taking Col B as a pointer and output the result of the match found in C
In C1, =IF(A1=B1,"match","no match") and copy down. Click to expand... I want to match same values in Col A taking Col B as a pointer and output the result of the match found in C
A aquaflow Jul 10, 2008 #4 In C1, =IF(A1=B1,"match","no match") and copy down. Click to expand... Col A Col B Col 3 dog cat found cat dog Found rat bat not found mat hat not found
In C1, =IF(A1=B1,"match","no match") and copy down. Click to expand... Col A Col B Col 3 dog cat found cat dog Found rat bat not found mat hat not found
