Skip to main content
Workforce LibreTexts

5.3: VLOOKUP Information

  • Page ID
    13036
  • \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)\(\newcommand{\AA}{\unicode[.8,0]{x212B}}\)

    VLOOKUP is one of the lookup and reference functions, when you need to find things in a table or a range by row.  For example, use VLOOKUP to find a price of an automotive part or the letter grade of a final average.

    VLOOKUP location:  Click FORMULA tab, Lookup and Reference icon in the Function Library group. Find VLOOKUP option at the bottom of the list.

    VLOOKUP argument box:  When you click on VLOOKUP, an argument box appears like the one below:

    Taking one box at a time:

    Lookup Value:  The value you want to look up.

    Table array. The column number in the range that contains the return value.

    Col Index num (meaning Column Index Number)

    Range Lookup:  We do not need to use this box

    EXERCISE (not graded but helpful to you if you work your way through it.)

    • Prepare a simple spreadsheet like the one below.
    CC licensed content, Original

    5.3: VLOOKUP Information is shared under a not declared license and was authored, remixed, and/or curated by LibreTexts.

    • Was this article helpful?