An easy one if you know it, I used to but I can't remember at all and googling this isn't helping:

I'm trying to create a lookup that builds the table reference up with parts of text from other cells:

C14 = "X"
C15 = "S"

=XLOOKUP([@W],Table_actual_SKU[SKU depth],"Table_actual_SKU["&C14&C15&"]")

Clearly the above doesn't work, but I can't remember for the life of me the function that allows me to build up the text of a reference that allows Excel to then use the complete reference:

=XLOOKUP([@W],Table_actual_SKU[SKU depth],Table_actual_SKU[XS])