range_lookup(0/1)parameter when using vlookup

[Ramesh Deo]

Dear All Excel Gurus,

Please share ideas which will help me to understand range_lookup parameter.

=VLOOKUP(D1,$A$1:$B$8,2,)
=VLOOKUP(D1,$A$1:$B$8,2,0)
why both works as same even if omitted range_lookup parameter but if omitted range_lookup parameter, by default it works as TRUE or 1.

Regards
Ramesh

 

[Chihiro]

VLOOKUP with range_lookup TRUE returns approximate match to the value if there is no exact match found, without going over.

If there is exact match, it will return same value as range_lookup FALSE.

NOTE: Table array must be sorted in ascending order (smallest to largest)

 

[John Jairo V]

Hi @Ramesh Deo (and @Chihiro).

Please check this post:
http://forum.chandoo.org/threads/returning-multiple-values.24522/#post-147798

Blessings!

 

[Ramesh Deo]

Hi @Ramesh Deo (and @Chihiro).

Please check this post:
http://forum.chandoo.org/threads/returning-multiple-values.24522/#post-147798

Blessings!

now, its clear from Luke sir replied thread.

thanks for sharing this thread.

 

[Chihiro]

Ah! Missed the "," at end. Good explanation thread.