Index and double match # INVALID VALUE

hennsab

Hey everyone,

I'm trying to return a value that matches two criteria in a cross sheet reference. It works just fine for the first cell but when I replicate for the others it returns a #INVALID VALUE.

=(INDEX({FUP - VETCO 2022 Range 7}, MATCH($[PO Line]@row, {FUP - VETCO 2022 Range 9}, 0), MATCH($PO@row, {FUP - VETCO 2022 Range 8}, 0)))

Paul Newcome

Are you able to provide a screenshot of your ranges?