The attached spreadsheet has a list of modules and their corresponding marks and pass or fail status. On the right (two columns that are highlighted in yellow), I need to fill up the status of the modules using look-up and match functions or any other suitable Excel functions.