The VLOOKUP formula searches for a value in the first column of an array and returns a value to the right of that array.

How about if you wanted to return a value to the left hand side of that array?

Well, this is where the INDEX-MATCH formula comes in and gives you a helping hand!

It searches the row position of a value/text in one column (using the MATCH function) and returns the value/text in the same row position from another column to the left or right (using the INDEX function).

Formula breakdown:INDEX(array, MATCH(lookup_value, lookup_array, [match_type])
What it means:INDEX(return the value/text, MATCH(from the row position of this value/text))



Index-Match - Intro




If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Create a Random List with Excel’s RAND Formu... What does it do?Gives you a random number between 0 and 1Formula breakdown:=RAND()What it means:=RAND(Will automatically choose a random number between 0 and 1)Excel is able to do a lot of things that most users are unaware of!  One thing that amazes m...
Free Excel Formulas & Functions Webinar Train... In this popular Free Excel Formulas & Functions Webinar Training which goes for 60 minutes you will learn the MUST KNOW Excel Formulas to ADVANCE your Excel skills!You will learn the following Excel Formulas & Functions: IF, SUMIF, VLOOKUP, INDEX/MATCH + MORE...!P...
Sum the Last 7 Transactions with the Offset Functi... What does it do?It returns a reference to a range, from a starting point to a specified number of rows, columns, height and width of cellsFormula breakdown:=OFFSET(reference, rows, columns, , )What it means:=OFFSET(start in this cell, go up/down a number of ro...
Excel Subtotal Function – Avoid Double Count... What does it do?It returns a Subtotal in a list or databaseFormula breakdown:=SUBTOTAL(function_num, ref1)What it means:=SUBTOTAL(function number 1-11 includes manually-hidden rows & 101-111 excludes them, your list or range of data)***Go to the bottom...