ms excel training - 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