Channel: ExcelIsFun

Category: Education

Tags: formulas and functionsfilter array functionhighline collegemike girvinemtlookup firstduplicates in lookup tablelookup lastlookup most recent price with formulaexcel is funexcel magicexcel functionsexcel magic trick 1791excel funone lookup value return multiple itemsget last pricexlookup functionexcellookup functionfilter functionmicrosoft 365 excelemt 1791lookup and return all matching recordsexcel 365excel formulasexcelisfun

Description: Download Excel File: excelisfun.net/files/EMT1791.xlsx Learn three important lookup formula tricks: Lookup Last Item, Lookup First Item, Lookup and Return All Matching Records. Topics: 1. (00:00) Introduction 2. (00:13) Product Lookup Table 3. (00:46) Lookup First using XLOOKUP function (Microsoft 365 = New School) 4. (01:38) Lookup Last using XLOOKUP function (Microsoft 365 = New School) 5. (02:29) Lookup All Matching Records using FILTER function (Microsoft 365 = New School) 6. (03:32) Lookup First using VLOOKUP function (Any Version of Excel) 7. (04:18) Lookup Last using LOOKUP function and Array Operation (Any Version of Excel) 8. (06:11) Lookup All Matching Records using Complicated Array Formula (Any Version of Excel) 9. (06:39) What to do if lookup table is not sorted. 10. (06:49) Summary, Closing, Video Links