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?
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?