What do I use instead of COUNTA?

[HRSylver]

Good morning Excel-ers. I have an if statement that will print two different texts depending on the outcome and my logical test is:

COUNTA(VLOOKUP(C14,Sheet2!$D$2:$F$400,3,FALSE))=1

When C14 gives a number that's NOT in the specified range on Sheet2 I want it to return a 0 so 0 won't equal 1. Instead I get #N/A which somehow gets counted a 1 which throws my whole operation off.

It seems COUNTA is the wrong command to use... What command do I use to just return a 0 or 1?

 

[Jonmo1]

Try

=IF(ISNUMBER(MATCH(C14,Sheet2!$D$2:$D$400,0)),VLOOKUP(C14,Sheet2!$D$2:$F$400,3,FALSE),0)

Hope this helps...

 

[HRSylver]

Worked like a charm. Thanks buddy!