using an IF and VLOOKUP together. Please help :)

Hi all, this should be an easy one for you. I've been staring at it for too long and need a fresh pair of eyes.

The attached sheet has a vlookup, and it is returning as #N/A because the formula cannot find what the specific text i'm looking for.

Will make more sense if you open the attachment - however I need to add something onto the formula so that if the specific text isn't in the lookup list, then return a '0'.

Thanks all! I have highlighted the error in red.

What you need is an IFERROR function, not IF statement.

Below is the code.

Please Login or Register  to view this content.

easy!! thanks