Combining Two Index and Match Formula?

[thbutterflycollector_]

Hi,

I am trying to combine two Index and Match Formula.

1. The first part of the formula looks up a particular indices for a particular date to return a value.
2. The second part of the formula looks at which particular indices a contractor is working to to yield a TRUE / 0 answer but not all contractor's will have the same indices.

For the first part:

=INDEX(Base!D$2:D$9,MATCH(Calcs!$G14,Base!C$2:C$9)) shown in H14:J14

For the second part:

=INDEX(H$2:H$11,MATCH($F19,$G$2:$G$11,0)) shown elsewhere

The cells highlighted in red should in fact be zero as John Bloggs does not have those indices. Can these be combined or do I have to use an IF formula and also trying to do this without using any vlookups if I can?

 

[thbutterflycollector_]

I have managed to solve this myself with X Lookup. I have never used this function before.

=XLOOKUP($F14,$G$2:$G$11,H$2:H$11,"",0)*XLOOKUP(H$1,$H$41:$AH$41,XLOOKUP($G14,$G$42:$G$49,$H$42:$AH$49))