Dynamic Change the Xlookup Return Array

[smalik]

Is there a way I can dynamically change the Return Array based on a value in another cell in an Xlookup formula?

For example, I am trying pull the data in various columns from another tab using the "Lookup Code"(Column B) as my lookup value.

Row 1 is the column header from another tab. For example, the "Prior Account ID" is in Column C from the "List" (source) Tab
The Xlookup formula in cell C5 is: =XLOOKUP($B5,List!$B:$B,List!C:C)

Is there a way I can dynamically change the Return Array based on what is in row 1? i.e., XLOOKUP($B5,List!$B:$B,List!C:C) to change to XLOOKUP($B5,List!$B:$B,List!AH:AH) automatically for the subsequent columns.

I used to be able to change the column number in Vlookup dynamically but not sure how to do this in Xlookup?

Any help is greatly appreciated.

 

[Fluff]

How about

=INDEX(List!$A$2:$AH$1000,XMATCH($B5,List!$B$2:$B$1000),XMATCH(C$4,List!$A$1:$AH$1))

 

[smalik]

Awesome.... This works. I did not know the "xmatch" function. Learn something new everyday

 

[Fluff]

You're welcome & thanks for the feedback.