Change Formula

[luisitocarrion1900]

Hello, I have the below listed formula that was created here for me, but I need to change it from looking at H8 or D8 to just look at the whole column for example just H or D and if it find it copy the date were it matches


=IF(IFERROR(INDEX('Inventory Stats'!$H$8:$H$100,MATCH(D8,'Inventory Stats'!$D$8:$D$100,0)),IFERROR(INDEX('IRM Inventory Stats'!$H$8:$H$100,MATCH(D8,'IRM Inventory Stats'!$D$8:$D$100,0)),""))=0,"",IFERROR(INDEX('Inventory Stats'!$H$8:$H$100,MATCH(D8,'Inventory Stats'!$D$8:$D$100,0)),IFERROR(INDEX('IRM Inventory Stats'!$H$8:$H$100,MATCH(D8,'IRM Inventory Stats'!$D$8:$D$100,0)),"")))