hi there guys,
i need a help here..

i need to compare data in column a and b in sheet1 [m_cert check]

with

data in column b and c in sheet2 [m_cert]


and if the data is the same, it will execute "Yes" in column c of sheet1 [m_cert check]
if its not same, it will execute "No" in column c of sheet1 [m_cert check]

additional info,
the data in sheet2 [m_cert] will be updated daily and it will increase daily.

the data in sheet1 [m_cert check] is paste from another source before we do the check. but no worries, the data that is paste is just numbers and not from formula.

thank you in advance

i atached the sample of what i need in the result.Book2.xlsx