IF the value in the color column matches the color criteria (元) and the value in the shape column matches the shape criteria (L4), then I want to see "MATCH!". On the right is my attempt to use both criteria in an array formula, by combining them with AND. The third table shows an array formula that matches the shape. The second table shows an array formula that matches the color. The first table shows the match formula working properly without using an array formula. At the left, column D contains working match formulas for both color and shape in the list of items. Note: the above image has been updated to included the array formula curly bracesĪt the top right, we have the search criteria in 元 ("color") and L4 ("shape"). I reduced my problem to the following example: How do I get a nested 'AND' to work inside 'IF' in an array formula?
0 Comments
Leave a Reply. |