Avatar of agwalsh

asked on 

SumProduct and index formula not picking up the correct entry

I have a file (constructed with help from the great people here!) which I want to use to track people who have retired. I am attaching a sample file. Starting in L12, RES has been entered to show resigned. That  number (1) should be picked up in cell BR6 (which is built on a table starting in DV10. I can see it has identified this RES entry as true (DW12) but it's not picking that up in BR6. What am I missing? Thank you
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment

8/22/2022 - Mon