Part $3$: Clean the data and complete the VLOOKUP task

Read through how the VLOOKUP function works: Microsoft Excel VLOOKUP

Create a new Excel file.

Add the following columns.

a$.$ Company Name

b$.$ Year

c$.$ Sales

d$.$ Cost of Goods Sold

e$.$ Gross Profit

f$.$ Net Income

Use VLOOKUP to populate the Company Name from your files.

a$.$ For example, if using the naming convention above, the following would populate the Pfizer name:

$=$VLOOKUP$("$Entity Registrant Name"$\text{'},[$PFE$\_10$K$\_$FY$22.$xIsx$]$Document and Entity Information'!$A:$D$,2,$ FALSE$)$

The formula looks for the cell in the first row of the array with the value "Entry Registrant Name" and returns the value in the second column of the array in the file PFE$\_10$K$\_$FY$22.$xIsx and in the tab "Document and Entity Information. In this case the value in that cell is PFIZER INC.

You can see the power of VLOOKUP to quickly pull data from different sources. One could duplicate this formula and only change the file name to pull data from many sources, assuming the files are formatted the same $-$ that is the same array,