You’ve probably heard about the VLOOKUP function, but do you know how to automate it in Excel? This function allows…