View source for Excel Get a Column Value Corresponding to A Value Match in Another Column

=External=
* https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1

=Internal=
* [[Microsoft_Excel#Subjects|Excel]]
=Overview=
In a bidimensional table, scan a column looking for a specific value and return the corresponding value from another column. A very common example is a table containing the price of a stock, recored at different distinct dates. Return the stock price for a given date.

Use VLOOKUP(). VLOOKUP is useful when you need to find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID. 

<font size=-1>
 =VLOOKUP(What you want to look up, 
          where you want to look for it, 
          the column number in the range containing the value to return, 
          return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE).
</font>

"What you want to look up" can be a value or a reference to another cell that contains the value to look up.

The column numbers are 1-based.

::[[File:VLOOKUP.png|415px]]