Returning an alternative value if lookup cannot be found in array

[Queen_Of_Thebes]

I think I need to use an IF statement but I'm not sure how to do it ...

This is my current formula
=VLOOKUP(A6,Pricing!C11871,2,0)

If this value, A6, cannot be found in the array I get the following returned
#N/A
If #N/A is returned I want Excel to put 0 (zero)

How do I do that please?

 

[Don Guillett]

Look in the help index for
ISNA

 

[Pete_UK]

Like this:

=IF(ISNA(VLOOKUP(A6,Pricing!C11871,2,0)),0,VLOOKUP(A6,Pricing!
C11871,2,0))

Hope this helps.

Pete

 

[Queen_Of_Thebes]

Many thanks, this has worked a treat

Like this:

=IF(ISNA(VLOOKUP(A6,Pricing!C11871,2,0)),0,VLOOKUP(A6,Pricing!
C11871,2,0))

Hope this helps.

Pete

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete