Task : Build input validation routine controls (EXCEL)
Based on the findings above, you have determined that too many transactions are being entered into the PCard system for the wrong MCC. Paul would like you to design a prototype spreadsheet in Excel that allows administrative staff to enter in the PCard data (same columns/fields as the file you were given) but prevents them from entering in transactions in prohibited MCCs. He would also like the MCC description to appear. In addition, only valid employees should be allowed to be entered. Once the PCard number has been selected from a list, the PCard holder name should automatically appear. In addition, purchase and credit should be the only options for source type (Hint: Data Validation and Lookup). You may want to reorder the columns.
To assist you, your instructor is providing you with a list of valid MCCs.
Provide the steps on how to do data validation and vlookup in excel.