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

{=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


--
Wag more, bark less

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

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

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

--
Wag more, bark less


"Brad" wrote:

{=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


--
Wag more, bark less