Comparing to files want to find and identify exceptions

  • 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 but want to see if its possible to combine the validation into one.
    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: Comparing to files want to find and identify exceptions


    Jon - please do not open duplicate threads. It is only an hour since you first posted - please wait patiently. This is a forum manned by volunteers who give of their time freely and in their own time: it is not a 'service'. It may be several hours until someone who can help you comes along, someone who may currently be asleep on another continent.


    If you attach a sample workbook, you might get a faster response.

    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

  • Re: Comparing to files want to find and identify exceptions


    Ok very I understand ... sorry, I was not sure if I put the thread in the correct forum...

  • Re: Comparing to files want to find and identify exceptions


    I'll move it to the formulas section. Could you please provide a sample workbook?


    [sw]*[/sw]

    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

  • Re: Comparing to files want to find and identify exceptions


    In E3 copied down:


    =IF(COUNTIFS('Data Set 1 (2)'!C:C,B3,'Data Set 1 (2)'!D:D,C3,'Data Set 1 (2)'!E:E,D3)=0,"New","")

    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

  • Re: Comparing to files want to find and identify exceptions


    You're welcome! :)


    Worth waiting for, I hope ... :)

    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!