asked on
Match columns in google sheets
I need to set a formula to identify and match values from 2 columns to another one, that means if a value "X" doesn't find in the two columns it must be put in the third column.
I set the example below, but i need the opposite, i need to show in the result column the no matching value, that is the "1111" and the "2222" and let the result in blank for the match value between A and B column:
Thx a lot
| Column A | Column B | Column C Result | Formula in the result column C | |
| AAAA | AAAA | AAAA | =VLOOKUP(A:A;B:B;1;0) | |
| BBBB | BBBB | BBBB | ||
| CCCC | CCCC | CCCC | ||
| DDDD | 1111 | #N/A | ||
| EEEE | EEEE | EEEE | ||
| FFFF | FFFF | FFFF | ||
| GGGG | 2222 | #N/A |
Google* google spreadsheetsSpreadsheetsMicrosoft Excel
Last Comment
DEH Online SL
ASKER
Hello, thx for the answer. I test the formula and works for every row and just for that row. I need the formula to check all the row in the column A and B and show the non matching value in column C, here is an example of what i need:
I also tried the formula by columns, but it doesn't work the way i need. (=if(B:B=C:C,"",C:C)
Thx a lot for your help
| Column A | Column B | Coumn C |
| AAA | AAA | No show anything |
| BBB | BBB | No show anything |
| CCC | DDD | No show anything because the value DDD is in the column A:4 |
| DDD | FFF | Must show the FFF Value because that value isn't in the A column |
I also tried the formula by columns, but it doesn't work the way i need. (=if(B:B=C:C,"",C:C)
Thx a lot for your help
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thx a lot
Open in new window
This if statement will check column a and b and only print column b if they don't match. If they match it will not print anything.. Working example below