look up and return part numbers from a description and display the part number with demand

Hello All

please see attahed

Sheet 1
Data that’s pasted in daily, part number positions and all other data changes daily basis in terms or rows, columns are static

on tab BMW E89 (Z4)

I’d like column A to display the part numbers from sheet 1, based on the Description in D, But only IF there is a qty in H

I’ve manually typed the expected results in

Paul