microsoft excel courses tate - V look up

Hi Isabella

Thank you for your question.

You can use the VLOOKUP function to extract data that is stored on one sheet, and have it displayed or be used in a formula on an entirely different/separate sheet.

For example, if you have a table which contains values on one sheet that you want to look up (using VLOOKUP) and multiply the value by a figure on another sheet, you could do this.

I hope this answers your question.
Amanda