answersLogoWhite

0

In general in Excel, TRUE and FALSE are logical values, like indicating if something is true or not. In the case of VLOOKUP, you use them in the Range_Lookup argument to specify whether you want VLOOKUP to find an exact match or an approximate match. If you put TRUE or don't put anything an approximate match is returned. In other words, if an exact match is not found, the next largest value that is less than lookup_value is returned. If you put FALSE, VLOOKUP will try to find an exact match only and return an error if it doesn't find an exact match. So, by using TRUE or FALSE in the Range_Lookup argument, you are essentially saying it is true that you want an approximate match or it is false that you want an approximate match.

User Avatar

Wiki User

10y ago

What else can I help you with?