identify exceptions when comparing two files

  • Hello Guru's
    I need some help please, I'd like to create one formula that can do the below, I can create the vlookups for each individual function, I would like to see if its possible to combine the validation into one formula.
    I have two files I want to compare/validate and identify the exceptions, I want to match the contract number in column F1, vendor number in column f2 and part number in Column f3 to same columns in second file if they match return "Match" if they don't return "new"

    Thanks in advance...

  • Re: identify exceptions when comparing two files

    Duplicate thread closed. Continue in your original thread here:…04979&p=796687#post796687

    Ali :)

    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!