As per match case of Header IDs, return a subtracted values.

Hi,

Required a formula help for as per match case of Header IDs, return a subtracted values in Col-F as a result of Col D – Col B values.

Sample sheet with expected results are enclosed.





Thanks,

try this formula in f4
=D4-IFERROR(INDEX($B$4:$B$9,MATCH(C4,$A$4:$A$9,0)),0)