# n/a problem

Dear all
how do i replace all the #N/A as zero on my spread shhet when i use VLOOKUP?

many thanks

=IF(ISNA(YOURFORUMLA),0,YOURFORMULA)

Let me know if that works.

Originally Posted by lapot

Dear all
how do i replace all the #N/A as zero on my spread shhet when i use VLOOKUP?

many thanks

This should be fairly straight forward:

1) select all the data that is resultant of the V-lookup
2) Right click on mouse and choose: Past Special
3) Then choose "Paste Special Values"
4) Find and replace '#n/a' with '0' or just leave it blank.

thank you for your replies, both works but i prefer BigBas formula it is easy to put in a mackro.

thank you again