Building a lookup with parts of a table reference

[jraward]

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])

[Fluff13]

Try

Please Login or Register  to view this content.

Also as you are using xlookup you might want to update your profile as 2007 doesn't have it.

[jraward]

I've just discovered I can nest xlookups per this article:
https://exceljet.net/formula/xlookup...%20Explanation

immediate problem solved, but still have the question on how you build a table reference from other cells/text if anyone can help?

[Fluff13]

Did you see my post.

[jraward]

indirect - that's the one!! Thank you.

I didn't realise my profile was that old tbh! Also you're just down the road from me, I'm Melksham (our office used to be in Chips)

[jraward]

I did, thank you! I hadn't refreshed for a while.

[Fluff13]

Glad to help & thanks for the feedback.