Forum Discussion
Compare two column values using VLOOKUP function
COL1 COL2 Result (Matching/Not matching) 0029 0029 0029 (Yes) 0057 0218 No 0218 1132 0218 (Yes) 0367 1310 No 0726 2450 No 0729 2791 No 0826 3220 No 0913 ...
Assuming that COL1 is column A and COL2 is column B, enter the following formula in row 2 of the result column:
=IF(ISNUMBER(MATCH(A2, B:B, 0)), A2&" (Yes)", "No")
Fill down
It's not working
Demo workbook that shows the working formula attached.
- Thanks a ton!