Declaring the name of the variable from a cell value

[obener]

hi all,

i just wanted to know if there is a way of declaring a variable and setting the name of the variable from a cell value?

thanks

 

[JoeMo]

When you declare a variable you have to furnish a name for it. You can set the value of that variable equal to a cell's value. Why would you want to change the name of the variable?

 

[mikerickson]

Short answer, No.
Longer answer, Names can be referenced by the contents of a cell, but that doesn't sound like what you are looking to do.
Are you looking to have a list of text values matched with a list of other values, if so, a VLookup array is probably the best way.

What are you trying to achieve?

 

[obener]

that's what i thought but i just wanted to confirm it. What i'm going to do is go through a list of exams and see which ones are completed as each exam has multiple parts in them but I may just use counter(x) where x can change for different ones.