#n/a

[hmmmm]

Guys

What is the formula for changing #n/a to 0

I am doing a vlookup against names and pulling thorugh numbers. However if it cant find the name it returns N/A
This affects my average column

Can anyone help?

[davesexcel]

Checkout if(isna(....
http://www.mvps.org/dmcritchie/excel/vlookup.htm

[daddylonglegs]

Here's one option....

If your VLOOKUP formula is

=VLOOKUP(A2,B2:C10,2,0)

change to

=LOOKUP(10^10,CHOOSE({1,2},0,VLOOKUP(A2,B2:C10,2,0))