Select the sheet where you want to add the data. Now enter the following: =VLOOKUP(A2, WindowsReport!A:B, 2, FALSE) This will return the values from column B if its value is the same as the value from ...
Featured here, the Balance Sheet for A2 Milk Company Ltd, which summarises the company's financial position including assets, liabilities and shareholder equity for each of the latest 10 period ending ...