Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel Training and help » excel computer training london - VLOOKUP function
|
|
|
Bookmark this page|
The UK's most regular 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 computer training london - VLOOKUP function
Resolved · Low Priority · Version Standard
Reply
VLOOKUP function
I'm having some trouble with VLOOKUP. It doesn't seem to work unless the data table it is reading from is in alphabetical/numerical order.... but I'm sure this can't be right!For upcoming training course dates see: Pricing & availability
RE: VLOOKUP function
Hi KatieThanks for your question.
I think the answer lies in what you enter in for the 'range lookup' part of this function. This is the last part of the function where you enter in true or false.
If you enter in true for this part of the function, then the vlookup function will find the nearest possible match and display this. If you use true then the result that is displayed does depend on how the information is sorted - you do need to put it in some kind of order (alpahabetical or numerical) for it to work.
If you enter false for this part of the function, then the vlookup function needs to find an exact match. If you enter false then the result is not dependant on the information being sorted in a particular order.
I hope this helps you.
Amanda
|
 |
|
» Forum post: PDF |
Can I save documents in PDF format?
