Formula result returning #n/a

**Ulaw** · 10-21-2008, 05:01 AM

Here is the problem

I have a vlookup formula that looks up data in a specific table. now on occasion the vlookup will not find a result in the table and return with a #n/a. I understand why it is doing this but what i need to do is for the result to be a 0 instead of #n/a can i do this with conditional formating or something.

Thanks

**Stuie** · 10-21-2008, 05:07 AM

Hi Ulaw,

this should do the trick

=If(ISNA(vlookup(enter your vlookup here)),0,vlookup(enter your vlookup here))

that should work

**royUK** · 10-21-2008, 05:09 AM

You can use ISERROR Function

=IF(ISERROR(your formula here,0,your formula here)

If you have a lot of such functions it can slow calculation times. In which case you can use Con ditional Formatting to hide the error, see

http://www.excel-it.com/excel_condit...formatting.htm