Forum home » Delegate support and help forum » Microsoft Excel Training and help » ms excel training - VLookup
|
|
|
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. |
ms excel training - VLookup
Resolved · Low Priority · Version Standard
Reply Fri 21 Dec 2007, 16:59Delegate Calum said...
Calum has attended:
Excel Intermediate course
Excel Advanced course
VLookup
Why does MS Excel use the word True to mean approximate?
For upcoming training course dates see: Pricing & availability
RE: VLookup
Hi Calum, Thank you for your post, Well this is one of those questions that only Bill Gates knows the answer to; I can only assume that as there are two options available ie: True or False, Yes or No, On or Off, Microsoft has chosen these options to distinguish between the two kinds of VLOOKUP, the first being to find an exact match for the lookup which has been designated as FALSE or the default which means you can omit the extension FALSE in your search. For the other option which is attempting to find a value which is equal to or less than the lookup, Excel uses the TRUE extension. To my mind this is just an internal command to Excel to distinguish between the two options of Lookup. I hope that helps, and I wish you all the best for the New Year, regards Pete
|