XLOOKUP Help

New Contributor

I am trying to use XLOOKUP to return data from the following example...

 

=XLOOKUP(D4,GrpA!F1:J1,XLOOKUP(B11,GrpA!$F$2:$F$34,GrpA!$D$2:$D$34,,2))

 

What am I doing wrong?

0 Replies