Calgary_Neil
Board Regular
- Joined
- Apr 5, 2014
- Messages
- 79
Hi feeling dumb today,
I have a Structured Table called Experience with 2 columns Lvl, and Title and want find the CrtLvl (Current Level) of the CrtTitle (Current Title) using
CrtLvl = Application.Match( CrtTitle, Experience[Title], 0)
In this case the level = row number, but it could be expanded by wrapping this in a similar Index call.
What I'm not getting is how to wrap "Experience[Title]".
Being a onetime call I don't want to create to many variables, and being a Structured Table isn't the name globally predefined?
I have a Structured Table called Experience with 2 columns Lvl, and Title and want find the CrtLvl (Current Level) of the CrtTitle (Current Title) using
CrtLvl = Application.Match( CrtTitle, Experience[Title], 0)
In this case the level = row number, but it could be expanded by wrapping this in a similar Index call.
What I'm not getting is how to wrap "Experience[Title]".
Being a onetime call I don't want to create to many variables, and being a Structured Table isn't the name globally predefined?