If Vlookup returns error enter 0

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Midwest User - 28 Mar 2006 16:51 GMT

I have to build a lot of logic in to trap errors that are returned with V or
H lookups and it would be nice to be able to just return a 0 if the lookup is
an error.

If there is a way to do this I am not aware of it.

Reply to this Message

Bernard Liengme - 28 Mar 2006 17:11 GMT

=IF(ISERROR(your-lookup-formula),0,your-lookup-formula)
=IF(ISNA(your-lookup-formula),0,your-lookup-formula)
best wishes

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

>I have to build a lot of logic in to trap errors that are returned with V
>or
[quoted text clipped - 13 lines]
>
> http://www.microsoft.com/office/community/en-us/default.mspx?mid=a4761563-5643-4
23c-9360-526982bc2395&dg=microsoft.public.excel.worksheet.functions

Reply to this Message

barrfly - 28 Mar 2006 17:14 GMT

try = if(iserror(vlookup(a1,range,2)),0,vlookup(a1,range,2)) or
=if(isna(vlookup(a1,range,2)),0,vlookup(a1,range,2))

Signature

barrfly

Excel User - Energy markets

Reply to this Message