Spiga

INDEX/MATCH: Left Lookup Formula Excel

The MATCH  Formula/Function Returns the relative position of an item in
an array that matches a specified value in a specified order. Use MATCH
instead of one of the LOOKUP functions when you need the position of an
item in a range instead of the item itself.

Returning the Column Number and Row NumberWe can either take this a step further and ensure the
column_num
argument supplied is always correct by nesting another MATCH
Formula/Function into the column_num argument. The formula for this
would be;

=INDEX(DataTable,MATCH("RKP4",ID,0),MATCH("Name",Headings,0))

OR, with no Named Ranges

=INDEX($A$1:$D$9,MATCH("RKP4",$C$1:$C$9,0),MATCH("Names",$A$1:$D$1,0))With both the above examples, we can assure that moving the
Names
Column will not cause our formula to return an incorrect result.

This content was originally posted on http://officeresources.blogspot.com/ © 2008 If you are not reading this text from the above site, you are reading a splog

0 comments: