Excel Get a Column Value Corresponding to A Value Match in Another Column: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
(Created page with "=External= =Internal= * Excel =Overview= In a bidimensional table, scan a column looking for a specific value and return the corresponding value f...")
 
Line 1: Line 1:
=External=
=External=
* https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1
=Internal=
=Internal=
* [[Microsoft_Excel#Subjects|Excel]]
* [[Microsoft_Excel#Subjects|Excel]]

Revision as of 02:46, 18 July 2023

External

Internal

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