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
Bookmarks