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 » excel consulting - V lock up
excel consulting - V lock up
Resolved · Low Priority · Version Standard
RE: v lock up
Hi Zsanett
Thanks for your question.
You can do a vlookup on a list (data stored in a series of columns) as long as the lookup value is in the leftmost column of your list you should be able to get Excel to display data from in the same row as a particular lookup value.
For more information, use Excel Help to find vlookup, or use the insert function button to the left of the formula bar on your screen, locate the vlookup function and click the Help on this function link.
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. |
Excel tip:Quickly create a list of numbersThe fill handle in Excel has many uses. If a number is typed into a cell and then the fill handle is used, the number will be copied from one cell to the next. |