How can I lookup names in sheet 1 (Jan 2021) from sheet 2 (Data) of only such persons who have sales greater than zero and update the sales of other persons who are already exist in sheet 1 (Jan 2021). The persons who sales 0 should not be appeared in Sheet 1 (Jan 2021). Kindly advice.
Sheet 1 | Sheet 2 | ||||
Jan-21 | Data | ||||
Name | Sales | Name | Sales | ||
Kashif | 100 | Aiman | 0 | ||
Shahid | 50 | Ali | 0 | ||
Asif | 70 | Kashif | 150 | ||
Amir | 50 | ||||
Qazi | 40 | ||||
Asif | 70 | ||||
Shahid | 50 | ||||
Raza | 100 |