VLOOKUP in Excel in under one minute. Let’s go. I have a table with cookie names and their price and another table with cookies and I want to know their price. In this cell type in =VLOOKUP and open parentheses. First, what are we looking for? We’re looking for classic chocolate chip cookie. Comma. Second, where are we looking? Select this entire table. Comma. Third, tell it the column number where it can find the answer. The price is in the second column. I’ll type in 2. Fourth, do you want an approximate match or an exact match? I’ll type in false for exact. Hit enter and look at that. We got a match.