| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array in formula Vlookup changes when data list is added to | Excel Worksheet Functions | |||
| VLOOKUP does not work with array formula | Excel Worksheet Functions | |||
| Vlookup+ Select Next Earliest Value (Array formula?) | Excel Worksheet Functions | |||
| array vlookup formula help | Excel Discussion (Misc queries) | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
