index match question

Hi, any assistance would be greatly appreciated.

Attached is the lookup table and the input/output result.

I am not sure if a macro is better or if formula (index match formula) would be quicker. Kindly let me know, how to achieve the output?Sample.xls

Thanks!