Hello, Here is a sample sheet of the problem I am attempting to solve. The formula is in cell A4. Row 22,23 and 24 each have a missing Color/Shape/Weight element. The problem is, if I conduct a search using just 1 or 2 of the 3 search elements and line 22,23 or 24 meet the criteria they do not get not show up in the results. Also, if row 21 meets the search criteria, the results for column D and E show zero rather than an empty cell. It would be nice to resolve this issue but it is not near as critical as at least the row is in the results. Thank you