Excel Get a Column Value Corresponding to A Value Match in Another Column: Difference between revisions
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...") |
(No difference)
|
Revision as of 02:45, 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()