I didn't think they added anything but more confusion. I was reading too fast (read: not reading at all and jumped straight to playing with the worksheet you posted), and missed that SCATTER_PLOT was defined in the Name Manager, and spent longer than I'm willing to admit googling for documentation on this magic function that I somehow had overlooked that did exactly what I needed it to.

Yes, this works perfectly. I deleted my comments because they were based on me not paying enough attention.

Yes, I see I forgot to filter the $D$3:$D$16 so it didn't work properly in the other columns. Thanks. I also remade what I was trying to do using MAP with MAKEARRAY =MAKEARRAY(ROWS(J5#),COLUMNS(K3#),LAMBDA(a,b,INDEX(Table1[C]‌​,MATCH(1, (Table1[B]=INDEX(J5#,a))*(Table1[A]=INDEX(K3#,b)),0))))

Ok, more tweaking and I came up with this, which I think should work, but doesn't for some reason: =MAP(K3#,J5#,LAMBDA(a,b,INDEX($D$3:$D$16,MATCH(1,($B$3:$B$16‌​=a)*($C$3:$C$16=b),0‌​)))) Any thoughts on why this doesn't work?

With a bit more playing, I came up with this: K5 : =INDEX($D$3:$D$16,MATCH(J5#,FILTER($C$3:$C$16,$B$3:$B$16=K3,‌​NA()),0)) Which will spill the whole column. I've been messing with it trying to see whether I could spill it in 2D to generate the whole thing with one formula, but no luck so far. Any thoughts?

Thanks. Just learned about the Spill operator (#), that will come in handy on a lot of projects.