One of the forum members was kind enough to give me a formula for an issue I was having. The formula is =XLOOKUP(1,FILTER(Materials!$V$2:$FO$1411,Materials!$E$2:$E$1411=A10),Materials!$V$1:$FO$1,"",0). The formula works but there are some values that round up to 1 that provide inaccurate information. Is there a way to restrict the formula to only look for values that are an exact match to 1, and not results that have rounded up?
Bookmarks