In Excel, VLOOKUP is a lookup/reference function that helps you find an item in a table or range of cells vertically by their row. Four arguments comprise the syntax of the VLOOKUP function; the arguments are the value you want to use as a reference, the range or table of cells that hold the value you seek,... You’ll also find a few functions that help with tasks you might do exclusively in Smartsheet (work with data in a hierarchical list, for example). You can use these functions in formulas to manipulate data, to add or subtract dates, or to make calculations—to name just a few things you might want to do. Excel VBA VLookup: Step-by-Step Guide and 5 Code Examples to Use the VLookup Function in Macros By J.A. Gomez In this VBA Tutorial, you learn how to use the VLookup function within your macros. I am trying to get counts of certain values. This is in the same workbook but different sheets. On sheet 1 is where my formula lies. In a cell, I want it to look at sheet 2 column B and look for instances of "A", then I want it to look in the same row it found "A" and look at the value in column "N" and evaluate if there is an amount. The VLOOKUP function in Excel performs a case-insensitive lookup. For example, the VLOOKUP function below looks up MIA (cell G2) in the leftmost column of the table. Explanation: the VLOOKUP function is case-insensitive so it looks up MIA or Mia or mia or miA, etc. As a result, the VLOOKUP function returns the salary of Mia Clark (first instance). May 16, 2017 · I invited some Excel experts to share a list of their favorite Excel functions, and their responses are great! If you want to get more out of Excel, try using some of these functions in your work. Perhaps some of them will become your favorites as well.