Home

Announcing XLOOKUP for Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-829954%22%20slang%3D%22en-US%22%3EAnnouncing%20XLOOKUP%20for%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-829954%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20style%3D%22display%3A%20inline%20!important%3B%20float%3A%20none%3B%20background-color%3A%20%23ffffff%3B%20color%3A%20%23000000%3B%20font-family%3A%20Segoe%20UI%2CSegoeUI%2C'Helvetica%20Neue'%2CHelvetica%2CArial%2Csans-serif%3B%20font-size%3A%2015px%3B%20font-size-adjust%3A%20none%3B%20font-stretch%3A%20inherit%3B%20font-style%3A%20inherit%3B%20font-variant%3A%20inherit%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%2020px%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%3EVLOOKUP%20has%20been%20with%20Excel%20from%20the%20beginning%3B%20it%20was%20included%20in%20Excel%201%20for%20Macintosh%20released%20in%201985.%20For%2034%20years%2C%20VLOOKUP%20has%20been%20the%20first%20lookup%20function%20learned%20by%20Excel%20users%20and%20our%203rd%20most%20used%20function%20(after%20SUM%20and%20AVERAGE).%20In%20fact%2C%20it%E2%80%99s%20so%20fundamental%20to%20spreadsheeting%20that%20most%20users%20can%20recall%20the%20sense%20of%20achievement%20they%20felt%20when%20they%20first%20mastered%20VLOOKUP%3C%2FSPAN%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20style%3D%22display%3A%20inline%20!important%3B%20float%3A%20none%3B%20background-color%3A%20%23ffffff%3B%20color%3A%20%23000000%3B%20font-family%3A%20Segoe%20UI%2CSegoeUI%2C'Helvetica%20Neue'%2CHelvetica%2CArial%2Csans-serif%3B%20font-size%3A%2015px%3B%20font-size-adjust%3A%20none%3B%20font-stretch%3A%20inherit%3B%20font-style%3A%20inherit%3B%20font-variant%3A%20inherit%3B%20font-weight%3A%20400%3B%20letter-spacing%3A%20normal%3B%20line-height%3A%2020px%3B%20orphans%3A%202%3B%20text-align%3A%20left%3B%20text-decoration%3A%20none%3B%20text-indent%3A%200px%3B%20text-transform%3A%20none%3B%20-webkit-text-stroke-width%3A%200px%3B%20white-space%3A%20normal%3B%20word-spacing%3A%200px%3B%22%3EXLOOKUP%20is%20named%20for%20its%20ability%20to%20look%20both%20vertically%20and%20horizontally%20(yes%20it%20replaces%20HLOOKUP%20too!).%20In%20its%20simplest%20form%2C%20XLOOKUP%20needs%20just%203%20arguments%20to%20perform%20the%20most%20common%20exact%20lookup%20(one%20fewer%20than%20VLOOKUP).%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3EFind%20out%20all%20about%20XLOOKUP%20in%20this%20blog%20post%20from%20Excel%20PM%20Joe!%20%3CA%20href%3D%22https%3A%2F%2Fblog-insider.office.com%2F2019%2F08%2F29%2Fannouncing-xlookup%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fblog-insider.office.com%2F2019%2F08%2F29%2Fannouncing-xlookup%2F%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Jesse Gamble
Microsoft

VLOOKUP has been with Excel from the beginning; it was included in Excel 1 for Macintosh released in 1985. For 34 years, VLOOKUP has been the first lookup function learned by Excel users and our 3rd most used function (after SUM and AVERAGE). In fact, it’s so fundamental to spreadsheeting that most users can recall the sense of achievement they felt when they first mastered VLOOKUP.

 

XLOOKUP is named for its ability to look both vertically and horizontally (yes it replaces HLOOKUP too!). In its simplest form, XLOOKUP needs just 3 arguments to perform the most common exact lookup (one fewer than VLOOKUP).

 

Find out all about XLOOKUP in this blog post from Excel PM Joe! https://blog-insider.office.com/2019/08/29/announcing-xlookup/