Hello , I am taking excel classes so I am a novice using excel. Currently, I am trying to learn the different kinds of wildcard characters and how to use them. A video I was watching used an & character in front of the quoted asterisk wildcard character within this formula:
=vlookup(ABC&"*",$A$2:$A$8,1,false)
Why do I need to use an & character in front of the quoted wildcard?
Bookmarks