XLOOKUP to tables using dynamic reference cell issue with Return Array

[DobeJR]

Hey guys, first post here and I'm excited to be apart of this community!  Love Excel and finding ways to automate processes with formulas!

I recently started using XLOOKUP and now I want to XLOOKUP to Table Arrays, but I'm having an issue when My table columns are more than one AND I want to use INDIRECT(" ") and reference a cell...

See image where formula works and one where formula doesn't when I get to the Return Array/columns with multiple portions...

Works!

Doesnt work:

Any idea why it is giving me this error?

[#2]

You have only two arguments for the second XLOOKUP(A22, INDIRECT())

[#3]

@Sergei Baklan Ah I see.  Thanks!  I ended up switching off tables and using regular range formulas because my data set will expand over time and I think it will be more manual to update formulas referenceing a table that has had its columns # increase.