<\/p>\n
What does it do? <\/strong><\/em><\/p>\n Searches the row position of a value\/text in one column (using the MATCH<\/strong> function) Formula breakdown: <\/strong><\/em><\/p>\n =INDEX(array<\/span>, MATCH(lookup_value<\/span>, lookup_array<\/span>, [match_type]<\/span>)<\/p>\n What it means: <\/strong><\/em><\/p>\n =INDEX(return the value\/text<\/span>, MATCH(from the row position of this value\/text<\/span>))<\/p>\n The VLOOKUP<\/strong> formula<\/a> searches for a value in the first column of an array and returns a value to the right of that array.<\/p>\n How about if you wanted to return a value to the left hand side of that array?<\/p>\n Well, this is where the INDEX-MATCH<\/strong> formula comes in and<\/a> gives you a helping hand!<\/p>\n It searches the row position of a value\/text in one column (using the MATCH<\/strong> function) and returns the value\/text in the same row position from another column to the left or right (using the INDEX<\/strong> function).<\/p>\n
\nand returns the value\/text in the same row position from another column to the left or right (using the INDEX<\/strong> function)<\/p>\n
\n