gamalelsaadawi
New Member
- Joined
- Nov 27, 2023
- Messages
- 1
- Office Version
- 365
- 2021
- 2019
- 2016
- Platform
- Windows
- Web
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?
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?
