=VLOOKUP(What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact match — indicated as 1/TRUE, or 0/FALSE). Functions can be used to quickly find information and perform calculations using specific values…