assigning condition on Vlookup

**Shadmani** · 07-21-2009, 07:58 AM

Hi all,

can anyone help me ?
where to use the condition 0 & where to use 1 ?

=Vlookup(a2,array,column5,0)

The above the syntax ( to my knowledge, I have given the correct one )

Thanks
Mani

**martindwilson** · 07-21-2009, 08:15 AM

well the syntax is true/false not 1/0(but they work as well)
=Vlookup(a2,array,column5,true) returns largest closet to or = to if range is sorted ascending
=Vlookup(a2,array,column5,false) returns only if exact match
from help file which i suggest you read!
· If VLOOKUP can't find lookup_value, and range_lookup is TRUE, it uses the largest value that is less than or equal to lookup_value.
· If lookup_value is smaller than the smallest value in the first column of table_array, VLOOKUP returns the #N/A error value.
· If VLOOKUP can't find lookup_value, and range_lookup is FALSE, VLOOKUP returns the #N/A value.

**oldchippy** · 07-21-2009, 08:15 AM

Hi,

Take a look here on VLOOKUP

http://www.contextures.com/xlFunctions02.html

**Shadmani** · 07-21-2009, 11:05 AM

Hi Thanks for your response.

I am not clear. I have enclosed a excel sheet. Sheet 2.

I tried to Vlookup true as well as False from the master data, which is the sheet 1.

It is confusing. can you please explain ? sorry guys I am new to Excel.

Thanks
Mani

**oldchippy** · 07-21-2009, 11:26 AM

Hi,

hope this is what you want? I've inserted a helper column (which you can hide if you want) only on you have a FredK on Sheet2 and FredF on Master sheet so this will pick the right Fred

**martindwilson** · 07-21-2009, 12:37 PM

1. wasnt this resolved with the index match i gave you previously?
http://www.excelforum.com/excel-new-...n-vlookup.html
2. you need to make the range references absolute
=VLOOKUP(A2,mASTER!A3:E23,5,0)
should be
=VLOOKUP(A2,mASTER!$A$3:$E$23,5,false)
or else the range will change as you drag the formula down