Excel – Lookup value in column and return value from another column

You can build a lookup that allows you to specify the lookup column and return value column completely independently, and also control of the nature of the approximate match, if not exact. Here is the full function:

  • =INDEX(Return_value_range, MATCH(Lookup_value, Lookup_value_range, Match_type))
    • Return_value_range – The range that holds the return values
    • Lookup_value – The value you want to find in the lookup value array
    • Lookup_value_range – The range containing lookup values
    • Match_type – Exact (0), Nearest Greater Than (-1), or Nearest Less Than (1)

Comments are closed.