how to create a dynamic name
I get how create a dynamic name from the lecture but I couldn't do the exercise
I also had some troubles with that. And after looking it up online I believe this short lesson is not explained well at all. If you look up on Google the & operator and how to concatenate strings in excel it will be much more clear.
I had the same problem as mentioned by Stefano above. The solution provided doesn't work when applied to the exercise. Based on the lesson, the solution be something like: = &B3 "and" &B4 "operate in the" &C3 "industry."
However, the actual solution is: =B3 & " and " & B4 & " operate in the " &C3&" industry."
How would one know to add additional "&" and spaces, based on the instructional video? It doesn't explain any of those nuances. Thus, the lesson and the exercise do not link together well to adequately instruct on how to create dynamic naming in a sheet.