🤔 ABOUT THIS Lesson 👇
HOW TO USE XLOOKUP SEARCH MODE BY EXCEL IN A MINUTE
Welcome to Excel in a Minute!
Introduction
What are the different search modes you can choose from in X LOOKUP?
In this lesson, you will learn about the four search modes you can use in the function.
The X LOOKUP function searches a value and returns a corresponding value if the lookup value is found.
This function runs on six arguments where the last three are optional.
In this video, we will focus on the sixth argument called search mode.
The first two search mode options are technically the same but work on different directions regardless if your data is sorted or not, then returns the value from the first match it finds.
The search first-to-last option searches the lookup array from top to bottom or left to right; and the search last-to-first option searches for the lookup value from bottom to top or right to left of the lookup array. You can use these by inputting 1 and -1, respectively, as your sixth argument.
_________________________________________________________________________________________________
🤓 VIEW THE BLOG POST (in here you can download the presentation and the excel file) 👇
[ Ссылка ]
to download the files go to the bottom of the BLOG POST and pres the download button
___________________________________________________________________
🔔 SUBSCRIBE TO EXCEL IN A MINUTE ON YOUTUBE 👇
[ Ссылка ]
___________________________________________________________________
💥FOLLOW EXCEL IN A MINUTE ON SOCIAL MEDIA 👇
Instagram ► [ Ссылка ]
Facebook ► [ Ссылка ]
LinkedIn► [ Ссылка ]
___________________________________________________________________
🤔 ABOUT EXCEL IN A MINUTE 😃
ABOUT US
Excel can be Challenging , but EXCEL IN A MINUTE has simplified it for you. In less than 3 minutes, our videos will help you learn Excel tips and tricks faster than you have ever imagined. Learning is fast, skills are retained for life.
New Excel tutorials are released twice a week. Subscribe to our channel to be notified of new videos
Website ► www.excelintuitive.com
📚 RECOMMENDED RESOURCES 👇
If you found this video valuable, give it a like.
If you know someone who needs to see it, share it.
Leave a comment below with your thoughts.
Add it to a playlist if you want to watch it later.
DISCLAIMER: The information contained on this YouTube Channel and the resources available for download/viewing through this YouTube Channel are for educational and informational purposes only.
This description may contain affiliate links. If you purchase a product through one of them, I will receive a commission (at no additional cost to you). I only ever endorse products that I have personally used and benefitted from personally. Thank you for your support!
#excelinaminute, #Msexcel,#excelintuitive,#msexcel, #XLOOKUP
