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

• 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()