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

[LMF]

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]

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

 

[AJ]

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]

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]

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