Join Cells & Compare To Single Cells

    Hi all,
    Would really appreciate somebody helping as i've put this previously on here with no results. There is a formula already in there though does not work because what I want to achieve is to have Column A & Column C to Match Column E & Column F, to Return the Value YES or NO. I’ve Highlighted in ROW 947 one that should Say NO yet Says YES. Hope to here from anybody that could assist



    Cheers


    W

    Re: Matching Two Columns On The Left To The Right & Bring Back A Yes Or No


    i've used this formula. but the result is correct based on your field header? if it matches then return yes otherwise no?


    =IF(TRIM(CONCATENATE($A13,": ",$B13))=TRIM($F13),"YES","NO")

    Re: Join Cells & Compare To Single Cells


    Zimitry,
    If you use your formula the above example i put forward will still be incorrect & also your formula does not take into consideration the range as not all accounts are on the same line. Much appreciate your help.
    Cheers
    W

    Re: Join Cells & Compare To Single Cells


    Try


    =IF(LEFT(F11,7)&E11=A11&": "&C11,"Yes","No")


    Add the Trim bits if your data isn't clean.


    Cheers


    Richard

    If absence makes the heart grow fonder, and familiarity breeds contempt, perhaps my wife should live in Darwin?

Participate now!

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

Register Yourself Login