Look up and return data based on positive numbers only

hello All

Please see attahed

Is there a way to automate the following?
The data in Blue text is manually entered from the JLR tab, is there a way it can automatically return the data, I’m only interested in QTYS greater than zero and want it to ignore anything that has a zero value in column D on the JLR tab.

Excepted results is currently in blue


Paul

How about in M20 filled down & across
=IFERROR(INDEX('JLR '!B$2:B$170,AGGREGATE(15,6,(ROW('JLR '!B$2:B$170)-ROW('JLR '!B$2)+1)/('JLR '!$D$2:$D$170>0),ROWS($A$20:$A20))),"")

VBA
1) to ThisWorkbook code module

Please Login or Register  to view this content.

2) Shortages 9th sheet code module

Please Login or Register  to view this content.