» Retrieving the Column Header that Corresponds with a Matched Value
CATEGORY - Lookup Formulas
VERSION - All Microsoft Excel Versions
Looking up the range A2:C5 for each of the values listed in column E, and retrieving the corresponding column header for each match.
Solution:
Use the INDEX, SUMPRODUCT, MAX, and COLUMN functions as shown in the following formula:
=INDEX($A$1:$C$1, SUMPRODUCT(MAX(($A$2:$C$5=E2)*(COLUMN($A$2:$C$5))))-COLUMN($A$1)+1)
Book Store:
Recommended Books:
- Accounting the Easy Way
- Microsoft Office XP Step-By-Step (With CD-ROM)
- Windows XP Annoyances
- Wall Street Journal Guide to Understanding Money and Investing
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
No comments have been submitted.
