I am very happy to share that, new function of Microsoft Excel 365 that is #FILTER, earlier you using Filter Tools from Data Tab, but now its in function.
This function categorised under Lookup & Reference Function in Excel 365, The Filter Function help you to Filter a range of data based on criteria that you want to show.
I really wondered by using this function. If you want to Know more about it, Watch this video till the end.
Also Watch Vlookup with Match Function https://youtu.be/K1ZMmcRFuto
XLOOKUP Function in Excel https://youtu.be/15ziUhOp-3M
Index+Match Formulas https://youtu.be/ORn3h4KoNp4
Download Practice File From Here https://mega.nz/file/JnBT2YDa#VbL5Ae6mSZxSHwxAh3d4AdTKhglE7QkKCYKDT1UtgDI