Hi all,
I wanted to find out if it is possible to take the value in a cell say c1 on a sheet. I even named that cell to try to make this easier. Name is First I want to take the Value for First and add another word to it to use to look up a value.
NewName = [First]&"Name"
I can then write something like this.
if Value is [newname] then
do something.
I just cannot seem to get how to use the name to do this. Is this possible?
Thanks!
I wanted to find out if it is possible to take the value in a cell say c1 on a sheet. I even named that cell to try to make this easier. Name is First I want to take the Value for First and add another word to it to use to look up a value.
NewName = [First]&"Name"
I can then write something like this.
if Value is [newname] then
do something.
I just cannot seem to get how to use the name to do this. Is this possible?
Thanks!