BYROW, BYCOL, TOROW, TOCOL, FILTER, IFS & OR Eta Functions Do Lookup Magic. Re-do EMT 1426. EMT 1871

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,