• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Data Compare and result as true or false in result sheet.

aligahk06

Member
Dear All,
I have a sheet Mdata and Bdata and third sheet is result sheet.
I want to cross check data in Mdata sheet and data in Bdata sheet and result in result sheet as true or false in B4 and so on.
for ex. Mdata sheet value i.e A4, B3, B4 MATCH WITH BDATA SHEET THEN MATCH TRUE OR FALSE VALUE IN IN RESULT SHEET B4 AND SO ON.

Please find the attached sheet for ref.
 

Attachments

  • TestFileData.xlsx
    309.8 KB · Views: 7
aligahk06
Seems that You've collected ... many things
Press [ Do It ]-button in 'Result'-sheet
and
You would find out FALSEs ... or ... dot.
Then You could find out something!
 

Attachments

  • TestFileData.xlsb
    142.5 KB · Views: 2
Back
Top