98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses tate - V look up
microsoft excel courses tate - V look up
Resolved · Low Priority · Version Standard
Isabella has attended:
Excel Intermediate course
Excel Advanced course
V look up
Can a V Look up be excercised from two completely seperate excel worksheets?
RE: 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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |