For eg. In the below data, we may not remember the full name of sales person, but we know that her name starts with jac. Now how do you get the sales amount for that person?
SolutionSimple. Use wild cards. Like this:
=VLOOKUP("jac*",$B$5:$E$17,3,FALSE)to fetch the value from 3rd column for the person whose name starts with jac