In this Video you will learn about Ms Excel most powerful function XLOOKUP. now start Forgetting to use VLOOKUP, HLOOKUP, LOOKUP, INDEX+MATCH.br Because XLOOKUP will Lookup data like every functions mention over here. br Not only this, by using XLOOKUP function you can handle error with the same function in place of IFERROR. where you use IFERROR Function with VLOOKUP and with other to remove error, but this function handle error also at the same time in a single function only.