VLOOKUP help in excel

[Columbo]

The are 2 tabs, tab 1 is running a vlookup against tab 2 and returning a value when it finds a match.

Screenshot below of sample data:

Is there a way to replace the '#N/A' with something that excel will recognise as a value when it does not find a match in tab 2.

I want to add up the number of positive return values that it finds.

Clear as mud I'm sure but any help appreciated.

 

[Columbo]

Mighty helpful of you fellas.

Worked brilliantly, have some cookies on me..!!!

 

[Columbo]

Right chaps another one for ya.

Anyway to get that VLOOKUP in my first post to look across more than tab at once?