Use the VLOOKUP function to obtain the financial statement data for the accounts listed in column A$,$ starting in cell A$30.$

In cell B$36,$ type $=$ vlookup$($

Click on cell A$36$ and press F$43$ times so that the $ sign is on the $"$A$"$ only $($as in $A$36).$

Type a comma $(,).$

Click on the worksheet tab for Company A$\text{'}$s financial statements.

Select the area from cell Al to well past the end of the Cash Flow Statement. I generally go past the end of the "lookup table" several rows just in case a company that I might be using this workbook for in the future has a longer set of financial statements.

Press F$4$ to make the cell references absolute$.$

Type a comma $(,).$

Click on the FinRatios worksheet tab.

Select cell B$34$ and press F$4$ twice $($to read B$$34).$

Type a comma $(,).$

Type "false".

Close the parentheses and press Enter.

Copy the VLOOKUP function across for the $5$ years of the company's annual income statements, then copy down for the rest of the income statement accounts.

Repeat the VLOOKUP and formatting steps for Company B$\text{'}$s income statement accounts starting in cell F$36.$