Hello everyone. Now #VLOOKUP is no more, because VLOOKUP replaced by #XLOOKUP(). Yes now we have to stay with new and improved more powerful function XLOOKUP, because, its do the job of #LOOKUP, #HLOOKUP, #VLOOKUP, #INDEXMATCH.br br This function is a modern and replacement of VLOOKUP, HLOOKUP, and LOOKUP. XLOOKUP supports exact and approximate match, wildcards for partial matches, and lookups in vertical or horizontal and also lookup in reverse ranges.br br Watch this video to know more in detailbr br How to Get Free Office 365br br br Also Watch New Functions of Excel.