Index-Function

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 as per your need.

If you have more than one criteria then you need to apply triple VLookup. You can use Index Match function for triple VLookup in worksheet.

VLookup in reverse order allows you to lookup any value from right to left side. Lookup a value in reverse order use Index & Match function.

Index match is an important function which allows you to search the value. you can use index and match functions for advanced lookup.

Excel has many useful tricks which is very useful for us. You can use given trick to get the file names from a folder using Excel function.

Index Match function allows you to search specific value from right to left and return exact value . This function also reduce load time.