Excel’s vlookup function is the most common lookup function. It’s often used in job interviews as bare minimum proof of Excel knowledge.
Are you using vlookup correctly?
Download my Excel file
Download here or via my OneDrive (file 00016)
Watch my YouTube video