Vlookup

dneas · Mar 4th, 2002, 03:30 PM

Why does this not work?

=IF(iserror(VLOOKUP(A9,[Feb02data.xls]report!$B$1:$D$30,3),0,VLOOKUP(A9,[Feb02data.xls]report!$B$1:$D30,FALSE))

Aladin Akyurek · Mar 4th, 2002, 03:38 PM

Quote:

On 2002-03-04 14:30, dneas wrote:
Why does this not work?

=IF(iserror(VLOOKUP(A9,[Feb02data.xls]report!$B$1:$D$30,3),0,VLOOKUP(A9,[Feb02data.xls]report!$B$1:$D30,FALSE))

It should be:

=IF(iserror(VLOOKUP(A9,[Feb02data.xls]report!$B$1:$D$30,3,0)),0,VLOOKUP(A9,[Feb02data.xls]report!$B$1:$D$30,3,0))

You could also use instead:

=IF(COUNTIF([Feb02data.xls]report!$B$1:$B$30,A9),VLOOKUP(A9,[Feb02data.xls]report!$B$1:$D$30,3,0),0)

0 as the last arg in VLOOKUP is the same as FALSE.

dneas · Mar 4th, 2002, 04:06 PM

Worked Great - thanks!!!!!

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

Mar 4th, 2002, 03:30 PM	#1
dneas New Member Join Date: Mar 2002 Posts: 34	Why does this not work? =IF(iserror(VLOOKUP(A9,[Feb02data.xls]report!$B$1:$D$30,3),0,VLOOKUP(A9,[Feb02data.xls]report!$B$1:$D30,FALSE))

Mar 4th, 2002, 04:06 PM	#3
dneas New Member Join Date: Mar 2002 Posts: 34	Worked Great - thanks!!!!!