How to use numerous pricing tables in umbers

Assuming your AGENT 1 and AGENT 2 tables have the same structure and headers at the top and left and you use the same agent name in the invoice table as you do for the name of the corresponding table, then you can use INDIRECT, OFFSET, and XMATCH to do the lookup, something like this:

=OFFSET(INDIRECT(B2&"::$A$1"),XMATCH(C2,AGENT 1::$A),XMATCH(D2,AGENT 1::$1:$1))

More on these functions here:

OFFSET - Apple Support

XMATCH - Apple Support

INDIRECT - Apple Support

The basic idea: OFFSET counts down and right from the A1 anchor cell in the relevant table. The two XMATCH functions calculate how my rows down or columns right and feed the results to OFFSET. The INDIRECT constructs the address of the relevant table from what it finds in column B.

SG

Once you've got it all working to your satisfaction then you can hide the red warning triangles by wrapping the formula in IFERROR, something like this:

=IFERROR(OFFSET(INDIRECT(B2&"::$A$1"),XMATCH(C2,AGENT 1::$A),XMATCH(D2,AGENT 1::$1:$1)),"")

That is:

=IFERROR(your-original-formula,"")

SG