Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Wondering if it's possible to achieve the following without using OR's (i.e.
via array formula or similar) I have product information in a straight data dump from our point of sale, and a table of categories, suppliers or product groups to exclude from further reports (in a single column list). Such that: D4 = Category E4 = Supplier I4 = Product group I want a response: If the category, or the supplier, or the product group is in the list of exclusions, then response should be "DO NOT REPLENISH" I can do it easily enough with a IF(OR(MATCH(D4......) [3 match statements]),"DO NOT REPLENISH","OK") but wondering if there is a nicer/cleaner way to do it Thanks in advance. -- Cheers, RyanR |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sumproduct(match range of values in 2+ cols) | Excel Worksheet Functions | |||
Match values and create a list in one cell | Excel Discussion (Misc queries) | |||
Validation - Ensure Cell values match | Excel Discussion (Misc queries) | |||
count if range contains match to another cell | Excel Discussion (Misc queries) |