To compare columns A in two sheets and if much join column B

Try this in column f cell F2
Assuming there are two sheets
1. Status
2. Report

Formula:

=Index(Status!$B:$B,match(Report!$A2,Status!$A:$A,0))

Change the reference accordingly...