Is there a way do to this without array formula or vlookup

B

Brad

{=IF(OR(C5=InpBox7),1,0)}
works
=IF(OR(C5={16,17},1,0)
works
Can a formula be written without using vlookup or array formula's and using
InpBox7 ?

InpBox7 is a range name of two cell with the values 16,17
 
B

Brad

one way
=SUMPRODUCT(--(InpBox2='1STqtrTax'!C7))

Are there better ways? (Isn't SUMPRODUCT truly an array formula?
 
Top