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.

Learn how to perform Excel multiple column lookups with ease using XLOOKUP, FILTER, SUMPRODUCT, and Boolean logic techniques.