New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Combination of Index and Match to Replicate Vlookup

Free Excel Tips and Tutorials

Combination of Index and Match to Replicate Vlookup

Postby Deepak Shashidharan » Thu Apr 26, 2012 3:54 am

Hi,

Drawback of VLOOKUP is the, first column always needs to be the LookinRange and the ReturnRange column should be always on the right, so it creates an additional works if leftside information is required, user has to manually copy paste it to the right. With the combination of INDEX and MATCH you can get the value on the left and even in the rows. Below is the command.

=INDEX("ReturnRange",MATCH("LookValue","LookInrange",True))

NOTE: The Returnrange and the LookInRange should start and end with the same Row (if looking values in a columns) and same columns (if looking values in rows)
Deepak Shashidharan
Rookie
 
Posts: 3
Joined: Apr 26, 2012
Reputation: 0
Excel Version: Excel 2007

Return to Excel Tips and Tutorials

Who is online

Users browsing this forum: No registered users and 29 guests