Super Charge Your Projects!!

~ Dirty tricks to increase speed, efficiency, and productivity in your MS Office projects ~

Super Charge Your Projects!! - ~ Dirty tricks to increase speed, efficiency, and productivity in your MS Office projects ~

Index & Match Functions – A More Flexible VLOOKUP!!

MATCH FUNCTION

INDEX FUNCTION

MATCH FUNCTION

Function: a lookup function that returns the relative position of an item in a list

=MATCH(lookup_value,lookup_array,match_type)

Parameters: 3

  • lookup_value = the value you use to find the value you want in a table.
  • lookup_array = contiguous range of cells containing possible lookup values.
  • match_type = tells index which row to look at.

0 = Exact Match

1 = Approximate Match (less than the lookup_value)

-1 = Approximate Match (greater than the lookup_value)

INDEX FUNCTION

Function: lookup function that can do a two-way lookup.

=INDEX(array,row_num,column_num)

Parameters: 3

  • array = the two dementioanl table
  • row_num= tells index which row to look at
  • column_num = tells index which row to look at

Your email address will not be published. Required fields are marked *

*