Vlookup

[dneas]

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]

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]

Worked Great - thanks!!!!!