result of vlookup = #N/A, how to replace it by "0"

**ChantalR** · 10-22-2007, 03:53 AM

The title already says it: i would like the result of a vlookup to be automatically turned into zero if the value is not found in the reference list.

I already tried this =if(vlookup(A1;c2:f24;3;false)="#N/A";0;vlookup(A1;c2:f24;3;false))

but that did not work

thanks in advance for any help !
& greetings from brussels
x

**daddylonglegs** · 10-22-2007, 04:19 AM

Try

=if(isna(vlookup(A1;c2:f24;3;false));0; vlookup(A1;c2:f24;3;false))

**ChantalR** · 10-22-2007, 05:26 AM

it works, great, thanks !!

**Elisius** · 07-23-2012, 01:21 AM

Hi

I need to do this too. but for some reason it just won't work and comes up with the below. what am I doing wrong?

error.png

**protonLeah** · 07-23-2012, 01:39 AM

Please start your own thread and post a workbook, not a picture.

**Cutter** · 07-23-2012, 11:32 AM

Hello Elisius, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.