mardi 27 janvier 2015

if the comparison of two columns is true, then compare their corresponding value in the next two columns and report true/false

Can't seem to get this one. I am comparing in excel if 2 columns (A and H) have any matching document #'s with



=NOT(ISNA(VLOOKUP(H3,$A:$A,1,FALSE)))


If this returns TRUE, I want to compare the revision # corresponding to each document # and return TRUE or FALSE as well. I have the first VLOOKUP working correctly but now I'm unsure how to use a nested if and be sure it is extracting the corresponding revision #. Your assistance is very much appreciated.


*So basically it is an If true, then if true....


Aucun commentaire:

Enregistrer un commentaire