
In the last week of August, Microsoft announced a new function ‘XLOOKUP’ as an upcoming successor of famous functions such as VLOOKUP and HLOOKUP. Before I start to Explain what is XLOOKUP and How to use XLOOKUP Function, I want to tell you about VLOOKUP‘s incredible history.
VLOOKUP was in existence since the First version of excel in 1985, 34 years ago. Since then it has been the 3rd most used function of Microsoft Excel. Every Excel user started his way to become a professional by using the function VLOOKUP. But VLOOKUP has some notable limitations, to overcome them Microsoft has decided to introduce a VLOOKUP killer function i.e. XLOOKUP.
You will be able to use XLOOKUP in newer versions of Microsoft office to come, for now, it is just available for the Office Insiders. So you have some more period to wait for before you can start using this function.
How XLOOKUP is Better than VLOOKUP?
By reading this, you will come to know how XLOOKUP is superior to VLOOKUP and HLOOKUP, and how It is going to make up for the limitations of VLOOKUP.
What is XLOOKUP?
XLOOKUP was announced on Wednesday, August 28, 2019, for a certain percentage of Office Insiders. It is named so because it can look in Multiple directions like Horizontal and verticle. It has 5 arguments that will fulfill all your lookup needs. The structure of the XLOOKUP is as shown.
=XLOOKUP(Lookup_Value, Lookup_Array, Return_Array, [Match Mode], [Search Mode])
We will how to use XLOOKUP in detail further in this article.
Why release a new Xlookup function?
While excel users were using VLOOKUP function widely, It has some limitations which are fixed by the XLOOKUP function, though the advanced users can turn to INDEX/MATCH function but most of the users find it difficult. The Key Features/Advantages of XLOOKUP over VLOOKUP are as follows.
- Can perform lookup to the left: VLOOKUP searches for the first column and returns the value which is to the right. Users have to rearrange their data to lookup value which is to the left. while XLOOKUP can Find a match anywhere irrespective of the direction.
- Can find the last match: In XLOOKUP, we can find the last match as well, which is not possible in VLOOKUP which gives only the first match.
- Defaults to an exact match: XLOOKUP defaults to an exact match which is its 4th argument. whereas VLOOKUP defaults to an Approximate match.
- Has Speed Improvements: XLOOKUP has all the speed improvements of VLOOKUP 2018. The performance of XLOOKUP is better as we specify only two columns instead of the whole table.
- Can insert/delete columns: Using XLOOKUP user can insert or delete the columns as it does not rely on the column number like VLOOKUP.
- Can search for the next large item: XLOOKUP has the 4th argument which is ‘Exact‘ by default but you can also search for the next large value.
- Returns Range instead of Value: XLOOKUP returns the range, unlike the VLOOKUP which returns a value. So it can be useful in Data Validation.
How to Use XLOOKUP function?
XLOOKUP is easy to Use. We will take a detailed look at how to use the XLOOKUP function. The basic XLOOKUP Function can even be used with only 3 arguments but if you want to perform an advanced Lookup you can use all five arguments of the function. Its syntax is as follows.
=XLOOKUP(Lookup_Value, Lookup_Array, Return_Array, [Match_Mode], [Search_Mode])
Let us go by an example. Suppose in the given data of the companies we have to find the ‘Company Name‘ by using the ‘Customer ID‘. Let’s try with VLOOKUP first.

Oops! VLOOKUP cannot be used in this Scenario as the Column index number is -2 which is less than 0, so you will get the #VALUE! error. VLOOKUP cannot find the value to the left of the lookup value it only works in the right direction.
Let’s try by Using the XLOOKUP function this time. Follow the steps to understand how to use the XLOOKUP function.
STEP 1: Specify the Lookup_Value i.e. the value you are looking for in the data table. In this case, it is cell G4 (Choose Customer ID).
=XLOOKUP(Lookup_Value, Lookup_Array, Return_Array, [Match_Mode], [Search_Mode])

STEP 2: Specify the Lookup_array i.e. the column in which you are looking for your Lookup_Value. In this case, it is Column C. Don’t forget to freeze it by pressing F4.
=XLOOKUP(Lookup_Value, Lookup_Array, Return_Array, [Match_Mode], [Search_Mode])

STEP 3: Specify the Return_Array i.e. which column you want to return. In this case, it is Column A. press F4. Notice how we can select a single Column In XLOOKUP which contains the return value, whereas in VLOOKUP we have to select the whole Table. The return_array is on the left-hand side of the lookup_array, which is again not possible in VLOOKUP.
=XLOOKUP(Lookup_Value, Lookup_Array, Return_Array, [Match_Mode], [Search_Mode])

STEP 4: Match_Mode allows you to select the type of match you want. The 4 options are:
=XLOOKUP(Lookup_Value, Lookup_Array, Return_Array, [Match_Mode], [Search_Mode])

- Use 0 to perform an exact match. XLOOKUP defaults as an exact match
- Use -1 to look for an exact match or the next smaller match in case no exact match is found.
- Use 1 to look for an exact match or the next larger match in case no exact match is found.
- Use 2 for wildcard character match
In our case, we need an exact match so we will keep it 0. Notice how 4th and 5th arguments are in square brackets it means they are optional.
STEP 5: Search_Mode allows you to select the type of Search you want XLOOKUP to perform. The 4 options are:
=XLOOKUP(Lookup_Value, Lookup_Array, Return_Array, [Match_Mode], [Search_Mode])

- Use 1 to perform the search from Top. XLOOKUP defaults as a First to Last search mode
- Use -1 to perform the search from Bottom/Last
- Use 2 and -2 to perform Binary searches on Sorted data which is ascending or descending.
In Our case, we need to search from first to last so we will keep it 1.
Press ENTER. Now the XLOOKUP is giving up the value ‘Fastners co.’ from column A. Our XLOOKUP is working perfectly where VLOOKUP could not do good.

What Happens to VLOOKUP and HLOOKUP?
VLOOKUP and HLOOKUP both will continue to be used in excel for now. Once you get your hands on XLOOKUP I suggest you to use the function because it is similar, simple and more effective.
Even though XLOOKUP is currently available for Microsoft Office 365 Insider program, that too for limited members. It might be coming out soon for everyone in future updates.
Please comment below if you liked this article or if you have any queries regarding this new function. Thank you!
To send your ideas and Suggestions to Excel Community use UserVoice. You can follow Excel on Facebook and Twitter to stay updated with Microsoft Excel.
https://over-the-counter-drug.com/# over the counter medicine for acid reflux
https://zithromax.science/# zithromax buy online
https://doxycycline.science/# doxycycline generic
https://amoxil.science/# amoxicillin 875 mg tablet
Some are medicines that help people when doctors prescribe. Read information now.
https://stromectolst.com/# ivermectin 80 mg
Prescription Drug Information, Interactions & Side. Learn about the side effects, dosages, and interactions.
Best and news about drug. Drugs information sheet.
stromectol tablets for humans
Read here. Everything information about medication.
Drug information. Generic Name.
https://stromectolst.com/# stromectol
Read here. Long-Term Effects.
Medicament prescribing information. Read now.
ivermectin rx
Medscape Drugs & Diseases. Some are medicines that help people when doctors prescribe.
Read now. Read now.
ivermectin lotion for lice
Actual trends of drug. Everything about medicine.
Long-Term Effects. Get here.
buy stromectol online uk
earch our drug database. What side effects can this medication cause?
Read information now. Everything what you want to know about pills.
ivermectin nz
Read now. Commonly Used Drugs Charts.
Read now. Read information now.
buy stromectol online
Get warning information here. Get information now.
Commonly Used Drugs Charts. Get here.
https://stromectolst.com/# ivermectin 2mg
Drug information. Some are medicines that help people when doctors prescribe.
Drug information. Learn about the side effects, dosages, and interactions.
ivermectin 90 mg
Get information now. Get information now.
Read now. Get information now.
https://stromectolst.com/# stromectol covid 19
Learn about the side effects, dosages, and interactions. Drugs information sheet.
Best and news about drug. Best and news about drug.
stromectol tablets uk
Actual trends of drug. Everything what you want to know about pills.
п»їMedicament prescribing information. Learn about the side effects, dosages, and interactions.
https://stromectolst.com/# where to buy ivermectin
Best and news about drug. Best and news about drug.
Read here. Definitive journal of drugs and therapeutics.
stromectol prices
Actual trends of drug. Comprehensive side effect and adverse reaction information.
Long-Term Effects. Definitive journal of drugs and therapeutics.
ivermectin cost canada
Get here. Get warning information here.
Read information now. Read information now.
ivermectin coronavirus
Everything about medicine. What side effects can this medication cause?
Everything information about medication. Get warning information here.
stromectol 3 mg tablet
Generic Name. Get here.
Get here. Everything information about medication.
can you buy stromectol over the counter
Top 100 Searched Drugs. drug information and news for professionals and consumers.
Best and news about drug. Medscape Drugs & Diseases.
where can i get cheap mobic without rx
Learn about the side effects, dosages, and interactions. earch our drug database.
Best and news about drug. earch our drug database.
https://levaquin.science/# buy cheap levaquin tablets
Read information now. Get information now.
Some trends of drugs. Read here.
https://lisinopril.science/# zestril medicine
Get here. Cautions.
Everything about medicine. Everything about medicine.
https://levaquin.science/# cheap levaquin pill
Comprehensive side effect and adverse reaction information. Definitive journal of drugs and therapeutics.
Top 100 Searched Drugs. What side effects can this medication cause? https://avodart.science/# can i order avodart
Top 100 Searched Drugs. All trends of medicament.
Commonly Used Drugs Charts. Get warning information here.
https://lisinopril.science/# lisinopril comparison
safe and effective drugs are available. Get warning information here.
Definitive journal of drugs and therapeutics. Best and news about drug. generic avodart without dr prescription
safe and effective drugs are available. earch our drug database.
Best and news about drug. What side effects can this medication cause?
cheap mobic without dr prescription
Drugs information sheet. What side effects can this medication cause?
п»їMedicament prescribing information. Drugs information sheet.
how can i get nexium tablets
Actual trends of drug. Read here.
Medicament prescribing information. Comprehensive side effect and adverse reaction information. where to buy generic avodart
Comprehensive side effect and adverse reaction information. What side effects can this medication cause?
drug information and news for professionals and consumers. Read information now.
where can i buy generic mobic without rx
Read here. Best and news about drug.
What side effects can this medication cause? Drugs information sheet.
https://lisinopril.science/# prinivil online
Drugs information sheet. Comprehensive side effect and adverse reaction information.
Everything about medicine. Long-Term Effects.
buy generic clomid without dr prescription
Read now. Commonly Used Drugs Charts.
Drug information. Drugs information sheet.
how to get cheap clomid without insurance
Cautions. What side effects can this medication cause?
Medicament prescribing information. Everything what you want to know about pills.
https://azithromycins.online/ zithromax 500 mg lowest price online
Read information now. Generic Name.
Read information now. Drug information.
how can i get cheap propecia without dr prescription
Cautions. Top 100 Searched Drugs.
Read here. Everything what you want to know about pills.
cost of generic propecia without dr prescription
Drugs information sheet. Some are medicines that help people when doctors prescribe.
Actual trends of drug. Read here.
can i buy propecia without dr prescription
Read here. Learn about the side effects, dosages, and interactions.
earch our drug database. Best and news about drug. amoxicillin 500 mg cost
Comprehensive side effect and adverse reaction information. Generic Name.
Read information now. safe and effective drugs are available.
can you buy zithromax over the counter in canada
drug information and news for professionals and consumers. Comprehensive side effect and adverse reaction information.
п»їMedicament prescribing information. All trends of medicament.
propecia pills
Cautions. All trends of medicament.
Read here. Everything about medicine. amoxicillin 500mg tablets price in india
Some are medicines that help people when doctors prescribe. Generic Name.
Generic Name. Generic Name. amoxicillin without prescription
drug information and news for professionals and consumers. Actual trends of drug.
Top 100 Searched Drugs. Prescription Drug Information, Interactions & Side. antibiotic amoxicillin
Get here. What side effects can this medication cause?
Everything what you want to know about pills. Get information now.
how to get cheap clomid
safe and effective drugs are available. Cautions.
What side effects can this medication cause? Long-Term Effects.
zithromax price south africa
Prescription Drug Information, Interactions & Side. safe and effective drugs are available.
Read information now. Read information now.
propecia prices
earch our drug database. Some are medicines that help people when doctors prescribe.
Actual trends of drug. Generic Name. order amoxicillin no prescription
Get warning information here. Read information now.
Medscape Drugs & Diseases. What side effects can this medication cause?
cheap propecia for sale
Get here. Prescription Drug Information, Interactions & Side.
Read here. Commonly Used Drugs Charts. amoxicillin 500mg capsules uk
Read information now. Best and news about drug.
Get warning information here. Drug information. generic amoxicillin over the counter
Some trends of drugs. Get here.
Drugs information sheet. Actual trends of drug.
https://edonlinefast.com best ed drugs
All trends of medicament. Comprehensive side effect and adverse reaction information.
Definitive journal of drugs and therapeutics. Get here.
https://edonlinefast.com top rated ed pills
earch our drug database. Everything information about medication.
Generic Name. Get information now.
cheap erectile dysfunction
earch our drug database. Get warning information here.
What side effects can this medication cause? Long-Term Effects.
ed pills that really work
Learn about the side effects, dosages, and interactions. Everything what you want to know about pills.
Actual trends of drug. Everything information about medication.
https://edonlinefast.com best drug for ed
Medscape Drugs & Diseases. Medscape Drugs & Diseases.
Actual trends of drug. Long-Term Effects.
ed treatments
Cautions. Comprehensive side effect and adverse reaction information.
Everything what you want to know about pills. safe and effective drugs are available.
erectile dysfunction drug
Learn about the side effects, dosages, and interactions. Generic Name.
Read here. earch our drug database.
zithromax generic cost
earch our drug database. Cautions.
Some trends of drugs. Definitive journal of drugs and therapeutics.
https://edonlinefast.com cheapest ed pills
Actual trends of drug. Learn about the side effects, dosages, and interactions.
Get information now. Some are medicines that help people when doctors prescribe.
best male ed pills
Everything what you want to know about pills. Everything about medicine.
Read information now. Generic Name.
non prescription ed pills
Definitive journal of drugs and therapeutics. Read now.
Drug information. What side effects can this medication cause?
best online canadian pharmacy
Get warning information here. What side effects can this medication cause?
Everything about medicine. Read information now.
https://canadianfast.online/# canadian online drugs
earch our drug database. Long-Term Effects.
Medscape Drugs & Diseases. Top 100 Searched Drugs.
canadian online drugstore
Some are medicines that help people when doctors prescribe. Read information now.
drug information and news for professionals and consumers. Cautions.
https://canadianfast.online/# non prescription ed drugs
Comprehensive side effect and adverse reaction information. Top 100 Searched Drugs.
п»їMedicament prescribing information. drug information and news for professionals and consumers.
https://canadianfast.online/# non prescription ed pills
Get information now. Commonly Used Drugs Charts.
Cautions. Learn about the side effects, dosages, and interactions.
https://canadianfast.online/# cheap pet meds without vet prescription
Everything information about medication. Actual trends of drug.
Definitive journal of drugs and therapeutics. Comprehensive side effect and adverse reaction information.
canada drugs online
Read information now. Read now.
Commonly Used Drugs Charts. drug information and news for professionals and consumers.
https://canadianfast.online/# buy prescription drugs from canada
Actual trends of drug. Medscape Drugs & Diseases.
Comprehensive side effect and adverse reaction information. Some trends of drugs.
canadian king pharmacy
Medicament prescribing information. Read here.
Get here. Prescription Drug Information, Interactions & Side.
https://canadianfast.com/# ed prescription drugs
Get warning information here. earch our drug database.
Some are medicines that help people when doctors prescribe. earch our drug database.
https://canadianfast.online/# amoxicillin without a doctor’s prescription
drug information and news for professionals and consumers. Top 100 Searched Drugs.
Long-Term Effects. Read information now.
best rated canadian pharmacy
What side effects can this medication cause? Everything what you want to know about pills.
drug information and news for professionals and consumers. Everything about medicine.
pet meds without vet prescription
Medscape Drugs & Diseases. Generic Name.
What side effects can this medication cause? Top 100 Searched Drugs.
https://canadianfast.com/# prescription drugs online without doctor
Some are medicines that help people when doctors prescribe. Everything what you want to know about pills.
Cautions. Everything information about medication.
viagra online canadian pharmacy
Best and news about drug. Drugs information sheet.
lanoxin 250 mg uk buy generic lanoxin 250mg molnupiravir 200mg canada
buy generic acetazolamide buy acetazolamide 250mg without prescription imuran 50mg ca
lanoxin 250mg us brand micardis 20mg molnupiravir us
Medscape Drugs & Diseases. Everything about medicine.
sildenafil 20 mg online pharmacy
What side effects can this medication cause? Everything information about medication.
Everything about medicine. Generic Name.
viagra with dapoxetine reviews
Generic Name. Medicament prescribing information.
Everything about medicine. Commonly Used Drugs Charts.
sildenafil female
Read information now. Read now.
Read now. Top 100 Searched Drugs.
sildenafil generic cheap
Everything about medicine. п»їMedicament prescribing information.
Everything information about medication. What side effects can this medication cause?
https://viagrapillsild.online/# viagra melanoma
Read now. Top 100 Searched Drugs.
buy carvedilol 25mg sale ditropan price buy amitriptyline pills
Comprehensive side effect and adverse reaction information. Generic Name.
brand cialis 20mg
Drugs information sheet. Top 100 Searched Drugs.
Commonly Used Drugs Charts. Definitive journal of drugs and therapeutics.
cialis and alcohol symptoms
Cautions. drug information and news for professionals and consumers.
Generic Name. Definitive journal of drugs and therapeutics.
https://tadalafil1st.com/# tadalafil pills 20mg
Generic Name. Commonly Used Drugs Charts.
Commonly Used Drugs Charts. Commonly Used Drugs Charts.
tadalafil generic in usa
All trends of medicament. Read information now.
drug information and news for professionals and consumers. Get here.
cialis using paypal in australia
Get warning information here. Commonly Used Drugs Charts.
buy amoxil 1000mg buy stromectol generic ivermectin 12 mg pills
buy alendronate 70mg generic order furadantin 100mg pill motrin 600mg us
Long-Term Effects. Drugs information sheet.
purchase cialis online cheap
Get information now. Get here.
Some are medicines that help people when doctors prescribe. Read now.
https://tadalafil1st.online/# buy cialis without doctor prescription
Some are medicines that help people when doctors prescribe. Everything information about medication.
cost priligy 60mg motilium over the counter motilium pills
safe and effective drugs are available. Best and news about drug.
https://tadalafil1st.com/# buy cialis online cheap
Cautions. Drugs information sheet.
All trends of medicament. Get here.
tadalafil canadian pharmacy price
Get warning information here. Everything about medicine.
Definitive journal of drugs and therapeutics. Read information now.
generic cialis tadalafil
Drugs information sheet. Comprehensive side effect and adverse reaction information.
Long-Term Effects. Read information now.
discount cialis from india
Actual trends of drug. Get information now.
buy nortriptyline order panadol 500 mg online paroxetine 10mg for sale
safe and effective drugs are available. Some trends of drugs.
https://tadalafil1st.online/# tadalafil soft gel capsule 20mg
Get information now. Definitive journal of drugs and therapeutics.
indomethacin pills cenforce 50mg tablet cheap cenforce
famotidine without prescription pepcid 40mg over the counter order remeron 15mg pills
order doxycycline 100mg pill buy methylprednisolone 16mg oral medrol
Everything what you want to know about pills. Medscape Drugs & Diseases.
https://clomidc.fun/ order generic clomid no prescription
All trends of medicament. Prescription Drug Information, Interactions & Side.
purchase ropinirole pills rocaltrol 0.25 mg usa buy labetalol 100 mg
tadalafil buy online purchase tadalafil without prescription buy amoxicillin 500mg online
purchase fenofibrate pill fenofibrate 200mg drug buy sildenafil 100mg online
earch our drug database. Read information now.
https://propeciaf.store/ order cheap propecia without insurance
Actual trends of drug. Learn about the side effects, dosages, and interactions.
buy nexium for sale brand clarithromycin 250mg order furosemide pills
buy generic cialis 20mg Cialis buy online buy sildenafil without prescription
Cautions. Medscape Drugs & Diseases.
zithromax buy
earch our drug database. Comprehensive side effect and adverse reaction information.
tadalafil 5mg oral ed pills that work the best ed pill
minocycline 100mg cost buy hytrin 1mg generic buy terazosin pills
no prescription drugs canada
provigil 200mg oral buy stromectol 6mg promethazine online order
metformin over the counter metformin order tamoxifen 10mg brand
prednisone 5mg uk deltasone 40mg canada buy amoxicillin pill
serophene uk clomiphene 100mg for sale cost prednisolone 20mg
buy generic fildena 100mg lyrica over the counter cost proscar 1mg
oral isotretinoin prednisone 5mg uk buy acillin for sale
Fantastic goods from you, man. I have understand
“밤의부산”
your stuff previous to and you’re just too fantastic.
zofran oral buy generic amoxil 1000mg trimethoprim for sale
stromectol medication buy pills for erectile dysfunction prednisone pills
Pretty section of content. I simply stumbled upon your site and in accession capital to assert that I
get in fact loved account your weblog posts. Anyway I’ll be subscribing to“강남풀싸롱”your feeds or even I achievement you get entry to constantly rapidly.
buy albuterol 2mg generic cheap levothroid online amoxiclav price
isotretinoin 40mg pill accutane 20mg pills buy zithromax sale
order provigil 100mg sale provigil 100mg pill lopressor where to buy
order prednisolone 5mg generic purchase gabapentin without prescription lasix online
avodart canada orlistat ca buy xenical 60mg generic
doxycycline 200mg ca zovirax 800mg over the counter buy zovirax 800mg generic
I have to thank you for the efforts you’ve put in penning this
blog. I’m hoping to view the same high-grade blog posts by
스포츠중계</a
you in the future as well. In fact, your creative writing
abilities has motivated me to get my own website now 😉
buy imuran 50mg generic naproxen 500mg generic naprosyn 250mg
buy cefdinir 300 mg generic purchase pantoprazole for sale protonix pill
ditropan 5mg brand buy ditropan 2.5mg generic cost oxcarbazepine 600mg
cheap dapsone oral dapsone 100mg tenormin over the counter
brand simvastatin sildalis pills female viagra sildenafil
cheap viagra viagra overnight tadalafil liquid