This is a Microsoft Excel tutorial covering Vlookup and Xlookup. The tutor starts off by explaining how to use the Vlookup function on some simple data. The tutor then covers what happens when the lookup column is not in the far-left position. The tutor then demonstrates how the Xlookup function works and how the Xlookup function overcomes the Vlookup error. This is a lookup tutorial. Vlookup or Xlookup, which is better. Vlookup or Xlookup in Microsoft Excel. Which is better? #xlookup #msexcel Join this channel to get access to perks: / @itseasytraining1st If you want to support me, check this out: / itseasy Online training courses: https://itseasytraining.teachable.com/ https://www.udemy.com/course/microsof... Playlists for this channel: Access: • Unleash the POWER of SUBMACROS in Access! Excel: • Link web based data into Microsoft Excel Word: • How to use Microsoft Word's mail merge fea... Visio: • How to create a basic network diagram in M... Project: • How to use Baselines and custom reports in... PowerPoint: • Zoom feature in Microsoft PowerPoint, New!... Publisher: • How to set or create Business information ... OneNote: • OneNote Overview, linking into Outlook tas... Office 365: • Video #itseasytraining Classroom based courses can be arranged at https://www.itseasy.co.uk/ Courses are available through Microsoft Teams, Online and Face to face in the UK Online courses at https://itseasytraining.teachable.com/ Udemy Courses https://www.udemy.com/user/stephen-sa... Training Guide Books Excel for New Managers https://www.amazon.co.uk/Excel-New-Ma... Microsoft Project Overview https://www.amazon.co.uk/Microsoft-Pr... Microsoft Visio Basic https://www.amazon.co.uk/Microsoft-Vi... Very cheap E_books are here: Excel For New Managers https://payhip.com/b/IE4x Microsoft Project Overview https://payhip.com/b/wY0m Microsoft Visio Basics https://payhip.com/b/5XeV Microsoft Access Introduction https://payhip.com/b/ynSL A PowerPoint Overview https://payhip.com/b/YkQv