VLOOKUP help in excel

Soldato
Joined
26 Mar 2007
Posts
9,118
Location
Nottinghamshire
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:

vlookup.jpg


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.
 
Right chaps another one for ya.

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