How can I modify this so it doesn't keep pulling the first item it finds in T2:T259 that is less than 20 and matches "SM05". I realize I'll have to have a formula in multiple cells for each result. I've attempted an Index Aggregate formula as well as an Index small formula. I haven't made them correctly thus far. Am I on the right path?
Sure, I copied the information that is needed. I want to pull the "code" in column A based on the name in column E of "SM05" and based on the number in column T (being less than 20). All this information is on sheet 1 named Product List. I want the name from Column A Sheet 1 to be placed in Sheet 2(Production Planner) in column Q.