super easy question for u guys, pls help me!!

LMF · Apr 9th, 2002, 10:17 AM

what is the difference between:

vlookup(A2, Range, 2, True)
&
vlookup(A2, Range, 2, False)

What difference does it make between true and false in a vlookup statement?
cause they seem to give u the same results

pls lmk

Ricky Morris · Apr 9th, 2002, 10:19 AM

the false assures you the desired result regardless if the data table is sorted or not. This is the option I ALWAYS use.

AJ · Apr 9th, 2002, 10:19 AM

The difference is as follows:

To find the closest match in the first column of the table (sorted in ascending order) use TRUE

To find an EXACT match, use FALSE.

Therefore, depending on your data, there may be no discernible difference.

Best to always use FALSE though in my view.

Rgsd
AJ

LMF · Apr 9th, 2002, 10:23 AM

i used false, when there is no exact match, it goes to zero, how can i make it blank easily?

pls lmk

Spock's Brain · Apr 9th, 2002, 10:24 AM

False returns an exact match on an unordered list. Returns NA if not found.
True returns the a value even if an exact match is not found . Returns previous lower number if not found. Requires an ordered list.

example:
2
3
5
6
a vlookup for 4 with TRUE would return 3
a vlookup for 4 with FALSE would return n/a because 4 is not there

Apr 9th, 2002, 10:19 AM	#2
Ricky Morris Board Regular Join Date: Mar 2002 Posts: 363	the false assures you the desired result regardless if the data table is sorted or not. This is the option I ALWAYS use. __________________ It's never too late to learn something new. Ricky

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 10:17 AM	#1
LMF Board Regular Join Date: Mar 2002 Posts: 73	what is the difference between: vlookup(A2, Range, 2, True) & vlookup(A2, Range, 2, False) What difference does it make between true and false in a vlookup statement? cause they seem to give u the same results pls lmk

Apr 9th, 2002, 10:19 AM	#3
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	The difference is as follows: To find the closest match in the first column of the table (sorted in ascending order) use TRUE To find an EXACT match, use FALSE. Therefore, depending on your data, there may be no discernible difference. Best to always use FALSE though in my view. Rgsd AJ

Apr 9th, 2002, 10:23 AM	#4
LMF Board Regular Join Date: Mar 2002 Posts: 73	i used false, when there is no exact match, it goes to zero, how can i make it blank easily? pls lmk

Apr 9th, 2002, 10:24 AM	#5
Spock's Brain New Member Join Date: Mar 2002 Posts: 18	False returns an exact match on an unordered list. Returns NA if not found. True returns the a value even if an exact match is not found . Returns previous lower number if not found. Requires an ordered list. example: 2 3 5 6 a vlookup for 4 with TRUE would return 3 a vlookup for 4 with FALSE would return n/a because 4 is not there