What does this part of the formula mean?

Noir · Apr 30th, 2002, 05:49 PM

=VLOOKUP(A2,Sheet2!$A$2:$B$1000,2,0)

What does the "2" and the "0" at the end of this formula mean? I have seen board members mention changing these last 2 numbers to suite your individual needs but, i don't know what these numbers do.

Please advise.

Thx,
Noir

lenze · Apr 30th, 2002, 05:58 PM

The 2 in the formula is the column number in the lookup table you wish to return data from. The 2 means the 2nd column. The 0 is short for FALSE. A 1 would be the same as TRUE. When FALSE is chosen, Excel only returns a value when an EXACT match is found.

Noir · Apr 30th, 2002, 06:06 PM

Thanks Lenze!

inarbeth · Apr 30th, 2002, 06:08 PM

Beat me to it Lenze. Unhelpfully, the online Excel help does not explain that 0 can be typed instead of FALSE as the range_lookup.

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

Apr 30th, 2002, 05:49 PM	#1
Noir Join Date: Mar 2002 Posts: 364	=VLOOKUP(A2,Sheet2!$A$2:$B$1000,2,0) What does the "2" and the "0" at the end of this formula mean? I have seen board members mention changing these last 2 numbers to suite your individual needs but, i don't know what these numbers do. Please advise. Thx, Noir

Apr 30th, 2002, 05:58 PM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 11,730	The 2 in the formula is the column number in the lookup table you wish to return data from. The 2 means the 2nd column. The 0 is short for FALSE. A 1 would be the same as TRUE. When FALSE is chosen, Excel only returns a value when an EXACT match is found.

Apr 30th, 2002, 06:06 PM	#3
Noir Join Date: Mar 2002 Posts: 364	Thanks Lenze!

Apr 30th, 2002, 06:08 PM	#4
inarbeth Join Date: Apr 2002 Location: Wivenhoe, England Posts: 850	Beat me to it Lenze. Unhelpfully, the online Excel help does not explain that 0 can be typed instead of FALSE as the range_lookup.