View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brad Brad is offline
external usenet poster
 
Posts: 846
Default 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