ms excel training

ms excel training - VLookup

Resolved · Low Priority · Version Standard

VLookup

Calum has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Calum [5 posts] (2007 Dec 21 Fri, 16:59) Reply

Why does MS Excel use the word True to mean approximate?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 5 Fri	Bayswater	0	FULL
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
2007	2008 Dec 10 Wed	Bloomsbury	2	book now	£240	£245
2003	2008 Dec 12 Fri	Southwark	4	book now	£224	£235
2003	2008 Dec 17 Wed	Southwark	1	book now	£235	£240
Full Schedule: See all 95 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: VLookup

by - trainer Pete platinum contributer [803 posts] (2008 Jan 2 Wed, 09:28) Reply

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