I have an excel with the following values in a row:
United States | 30 | 38 | 35
Italy | 10 | 10 | 11
Then I have another row with some cells with different values:
United States | 30 | 38 | 34
Italy | 10 | 12 | 11
I need to build a formula in excel which in the first step finds “United States” and “Italy”, then compare every coloumns… if the value matches I have to get “OK”, otherwise “KO”.
Taking the example above:
United States | 30 | 38 | 35 | United States | 30 | 38 | 34 | OK | OK | KO
Italy | 10 | 10 | 11 | Italy | 10 | 12 | 11 | OK | KO | OK