https://youtube.com/watch?v=o2cdp8_xnXAVLOOKUP is an Excel function to lookup and retrieve data from a specific column in table. VLOOKUP supports approximate and exact matching, How to use Vlookup function in excel sheet…