Hello;
I'm using structured table references as part of a lookup function.
What I would like to do is reference the contents of a cell (in this case, $C$1) to return the item description.
Structured Table1 [TABLE="border: 1, cellpadding: 1, width: 500"]
ITEM NO.
[/td]ITEM DESCRIPTION
[/td]PART #1
[/td]Red Ball
[/td]PART #2
[/td]Yellow Cow
[/td]
[/TABLE]
=Lookup("Part #1",Table1[ITEM NO.],TABLE1[$C$1]) (This does not work)
Where the Content of $C$1 is ITEM DESCRIPTION
Eventually I need to dynamically assign the structured reference via UI or macro output and not constantly change the formula.
Thanks in advance!