Index and double match # INVALID VALUE

Options

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)))



Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!