Download Excel File: https://excelisfun.net/files/EMT1870-1871.xlsx
Learn how to lookup a value in a rectangle range and return the row or column header with the best and easiest formula ever!!! I did a video 7 years ago (EMT 1426) and the formula was much harder. But now with MS 365 Excel: WOW!!! Everything is so much easier : ) Thanks to ExcelLambda from YouTube for the rad formulas!
Topics:
1. (00:00) Introduction.
2. (00:54) FILTER & BYCOL functions with the Eta Lambda OR Function to create lookup formula that returns column header (Sales Team / Sales Rep Lookup Table example).
3. (02:49) IFS & TOROW functions to create lookup formula that returns column header.
4. (04:19) What to do if there are multiple lookup value matches in the same row or column?
5. (04:19) Boomerang World Cup / Events Lookup Table example.
6. (04:54) FILTER, BYROW, OR lookup formula into rectangle range and return row headers.
7. (05:33) IFS, TOCOL, UNIQUE lookup formula into rectangle range and return row headers.
8. (06:18) Summary
9. (06:42) Closing
#excel #microsoft #excelisfun #excelcourses #excelcourse #excelfunctions #excelformula #excelfunction #365excel #office365 #office365training #exceltips #exceltutorial #exceltraining #exceltricks #excelmaster #excelmagictrick #excelmagic
#bycol #byrow #tocol #torow #unique #ifs #IFSFUNCTION #OR #orlogical #logicaltest #logical #lookup #twowaylookup #index #XLOOKUP #lookupcolumnheaders #lookuprowheaders #filter #filterfunction #reverse #reverselookup
Reverse lookup, Reverse Two Way Lookup, Lookup Column Headers, Lookup Row Headers,