Update stock when title and size matches between two Excel or Google Sheets

[gamalelsaadawi]

We have 2 sheets (Sheet 1) and (Sheet 2).
sheets1 has 3 columns (Title1) - (Size1) - (Stock1).
sheets2 has 3 columns (Title2) - (Size2) - (Stock2).
We want to update each cell in (Stock2) Column in (Sheet 2) when any cell in Title1 and size1 in sheet1 = any cell in Title2 and And Size2
**update value = "in-stock" in Stock2 when Stock1= "true" and = "out-stock" when Stock1= "false".
-If Title1 or Size1 doesn't match Title2 or Size2 don't update Stock2 and leave it as it is.
We want to
Is there a way to achieve that?