How to Use XLOOKUP in One Short Example

XLOOKUP in Excel is the easiest way to look for data, far superior to the clunky VLOOKUP method. In this video, we use the XLOOKUP formula to find a match between two tabs and return the data from a separate column when a match is found.

My cat, Logan, decided to make an appearance! Maybe he will be my permanent sidekick.

Chapters:
00:00 - Intro
01:00 - How to enter the XLOOKUP by typing it into the formula bar
04:35 - How to enter the XLOOKUP via the formula menu

#xlookup #excel #formulas #office365 #excel365

[OfficeMystic]

I am returning to this channel after a LONG hiatus; if you enjoyed this video, please subscribe and drop a suggestion below for future videos or if you have a general MS Office question. I would appreciate the subscription immensely! Thank you for your time.

[BeaverMonkey]

Is xlookup available in all versions of office or just 365?

[brittanyluerssen]

How would you do the same thing but only using the first 7 digits of your record number? So, to explain what I'm trying to accomplish. I have a list of BIN numbers in column B in sheet 1 and the corresponding bank number in column A of the same sheet. Example Bank # 123 (A2) Bin # 1234-56 (B2). Now to do my daily job, I import a list of cases from card company which will contain all info I need EXCEPT the bank numbers. (the card company does not know our bank numbers because they are for internal purposes) currently I spend a lot of time manually filling in bank numbers by control F in a separate source. I want to use a formula to match the first 7 characters if one cell in imported data, compare to BankBin table in sheet 2, and return the Bank number that is associated sheet 1 (the sheet with all the rest of the info)