There is a special function called isna(). Place your vlookup inside and test isna() with an if. For example:
:"=if(isna(vlookup(a1,c1:z20,2,false)),0,vlookup(a1,c1:z20,2,false))"
HTH
Rocky
Woops I just reread your post. The zeros will mess the average up. You are going to have to sum()/countif(b1:b20,">0") to figure the average. Unless someone has a better way.
Sorry...
Rocky
This message was edited by Rocky E on 2002-03-15 18:44
This message was edited by Rocky E on 2002-03-15 18:54