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 » Vlookup
Vlookup
Resolved · Low Priority · Version 2003
wayne has attended:
Excel Intermediate course
Vlookup
how do I edit a v:lookup to enter something in a cell as opposed to the formula so the cell acts like a search box?
RE: vlookup
Hi Wayne
Thank you for your question and welcome to the forum.
The VLOOKUP function has 4 parts - for the first part of the function (the lookup value), you can refer to a cell (e.g. A3) and then type into that cell what is it that you would like Excel to look for in the first/left most column of the table array (second part of the function). Then you can use cell A3 like a search box.
I hope this helps.
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:Removing custom dictionary entriesIf you add something to the custom dictionary in Excel you cannot remove it. The way to get around this is to go into word and remove it there. |