With these out of the way, let's get to writing that formula. You can also look up multiple values in a column with VLOOKUP.