XLOOKUP

I will show you how to search for any data column wise or row wise from a given set of data. I am using XLOOKUP function in Excel. This function is a little complicate, therefore, please watch carefully and practice it in any dummy data. I have shared a link below so that you can also download this excel workbook for practice. Download Link : https://docs.google.com/spreadsheets/d/1- MgJCLWHeqZuqHcAKZumDBaUiDaISgeo/edit?usp=sharing&ouid=104313050062582246510&rtpof=true&sd=true cells,columns,office 365,excel 2019,excel 2016,excel 2013,Advanced Excel tricks,Excel online course,Excel tips and tricks,Excel for analysts,Microsoft Excel tutorials,Microsoft Excel,Excel XLOOKUP,XLOOKUP,No more VLOOKUP,Excel Left LOOKUP,Approximate lookup,excel lookup error,lookup exact match,xlookup vs vlookup,hlookup with xlookup,two way lookup in excel,xlookup versus index matchatch,lookup rows and columns,excel lookup function,Excel office 365,excel 365,excel lookup wildcards Links Facebook Link : https://www.facebook.com/excelsolutionsbasicandadvanced/ Facebook Group : https://www.facebook.com/groups/416865405424675/ Blog : http://advanced-excel-solved.blogspot.com/ Other Related Videos You May Watch: Flash Fill : https://youtu.be/oZuB9m0gLP8 Embeding Excel : https://youtu.be/NV0jc-Tq_OE VLOOKUP: https://youtu.be/iggOdgU2M3k VLOOKUP Not Working: https://youtu.be/z3EwpTJMB5Y SUBTOTAL Function: https://youtu.be/n1JqTE8i8GA