In this video I have explain in detailed about Ms Excel Lookup & Reference Group Function #MATCH()
MATCH is used to locate the position of a lookup value in a row or column. This Function supports approximate and exact matching, and wildcards (* ?) for partial matches. if we combined MATCH Function with #HLOOKUP, #INDEX, OFFSET, VLOOKUP, its get so powerful and return the various type of result, we can say its a versatile Function of Excel.
To Know in detailed Watch this video till the end.
HLOOKUP Function
https://dai.ly/x7udf0d
https://youtu.be/LRzfKmZjtKk
LOOKUP Function in Excel
https://dai.ly/x7vyhz1
https://youtu.be/8nCotivDIMU
Index + Match with Example
https://dai.ly/x7vyhyz
https://youtu.be/NqAw5BstRGg
https://youtu.be/ORn3h4KoNp4
Download Practice File Here
https://mega.nz/file/puJEGYTS#OZJjGTiCg85eBr9viAIOC5yfa2PguOyB5HOwVVmMzqY
Comments