Can I get an Excel formula for if a cell is equal to a cell of a specific range, copy the cell next to the matching cell, otherwise show 0.

I.e. from the screenshot in D2, check if C2 is in the range of F2:F8 and if so, show 100 (the cell next to the corresponding F2) otherwise, show 0.

[![enter image description here](https://i.stack.imgur.com/mt8ub.png)](https://i.stack.imgur.com/mt8ub.png)