How to use Index Match function in Excel
Index Match function allows you to search specific value from right to left and return exact value . This function also reduce…
#Index-Function
6 postsGet the File Names from a Folder using Excel function
Excel has many useful tricks which is very useful for us. You can use given trick to get the file names from…
How to use index and match functions for advanced lookup in Excel
Index match is an important function which allows you to search the value. you can use index and match functions for advanced…
How to use Advance Backward VLookup in Reverse Order in Excel
VLookup in reverse order allows you to lookup any value from right to left side. Lookup a value in reverse order use…
Triple VLookup with Index Match function in Excel
If you have more than one criteria then you need to apply triple VLookup. You can use Index Match function for triple…
How to lookup images in Excel using Index Match function
If you need to lookup images in Excel then you must have to use Index Match function to quickly get the result…