Compare field values of two excel tables in different files

Asked

Viewed 272 times

0

I have two tables in 2 excel files, and I want to compare each value of the A column of the file_1 with each value of the A column of the file_2 and also each value of the F column of the file_1 with each value of the H column of the file_2. If equality is found in both cases, then the field in file column F 1 should change color.

Each value of each column will compare with all values of the respective column in the other file.

In pseudocode it would look like this:

if(A1_file1 == A1_file2 && F1_file1 == H1_file2){
      F1 muda de cor.
}
  • 1

    If you post an example, with images or some data can help a lot. I think you could try using PROCV for that reason...

  • 1

    The PROCV should be in conditional formatting for this... take a look at a template here: https://github.com/excelguru/controle-obligato/raw/master/Controle%20of%20Obrigacoes.xlsx

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.