Look ups

Hi Anna,

Thank you for your question and welcome to the forum.

You need to use a Nested function similar to the one below:

=if(iserror(vlookup(b2,e5:H15,3,false)),0,vlookup(b2,e5:H15,3,false))

The iserror function handles a host of error messages which include #N/A.

So the formula is saying, if there is an error from the vlookup formula, place a zero otherwise put the result of the vlookup formula.

I hope this answers your question.

Regards

Simon