Compare filename1 sheet1 with filename2

Closed
real2014
Posts
1
Registration date
Thursday July 16, 2015
Status
Member
Last seen
July 16, 2015
- Jul 16, 2015 at 05:59 PM
Hi all,
i need help, i want to compare filename1 sheet1 with filename2 sheet and result in filename3 sheet as pass or fail. filename1 sheet1 insert 2 columns and look for data from column b cells5, lookup in filename2 . copy text from filename2 sheet1 and paste in filename1 in inserted column and compare the two data and result in the file3

this is how filename3 look