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 » ms excel training - VLookup
ms excel training - VLookup
Resolved · Low Priority · Version Standard
Calum has attended:
Excel Intermediate course
Excel Advanced course
VLookup
Why does MS Excel use the word True to mean approximate?
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
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:Adding cells, Rows & columnsplace your cursor on a cell, row number or column letter and use CTRL + SHIFT + + or CTRL + + depending on which + you prefer to use. |