Could someone tell me why this isn't working? Just trying to INDEX & MATCH three criteria, which are one right after the other in a table, column B>index (what I want) columns C,D, & E have the criteria needed to filter to the correct item number.
{=INDEX('ITEM# Matrix'!B1:E2988,MATCH(O5,'ITEM# Matrix'!C1:C2988,0),MATCH(P1,'ITEM# Matrix'!D1:D2988,0),MATCH(V1,'ITEM# Matrix'!E1:E2988))}
Bookmarks