However youll need INDEX and MATCH to perform advanced lookups as we will see next. The INDEX function can also return a specific value in a two-dimensional range. Aise situation me aap Index Match use kar sakte he.
Finds the Value-Based on Coordinates.
Lekin Xlookup function sirtf Office 365 Excel version me hi uplabdh he. For short this is referred to as just the Index Match function. Finds the Value-Based on Coordinates. In the following image you are seeing some company names their origin country and market category.