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