Good day all. I could use a hand here.
The attached table is a simplified version of what I'm trying to pull results from. The data in column A can be repetitive, and I need the result to be specific to the regional designation (columns C through G). I cannot get an INDEX/MATCH to work for me. For example, I need to lookup sales for Item 100585, but for the NA region. My expected result would be 2169.69. However, My Formula {=INDEX(A1:G7,MATCH(J1,A1:A7,0),MATCH(L1,C1:G1,0))} finds the Item in row 2 and the data in column 4 (F), and returns 0. Appreciate any insight as to what I am missing - that is likely right in front of me! Thanks!
Bookmarks