Two column lookup in table array using INDEX and MATCH

by

Try an array formula (CTRL + SHIFT + ENTER) instead of Enter.

=INDEX(K9:K53,MATCH(K3&K4,I9:I53&J9:J53,0),1)

Not tested but should work.

Will edit later explaining our formula and reason why your formula doesn’t work.

More Related Contents:

  1. If two cells match, return value from third
  2. How to convert to percentage [closed]
  3. Sequence of numbers based on start and end value of 2 cells [closed]
  4. I have an Excel data sheet that I would like to extract data from into a new sheet
  5. Error in finding last used cell in Excel with VBA
  6. Getting unique values in Excel by using formulas only
  7. Vlookup using 2 columns to reference another
  8. Excel: last character/string match in a string
  9. Referencing value in a closed Excel workbook using INDIRECT?
  10. Simple Pivot Table to Count Unique Values
  11. Excel UNIQUE Across Columns
  12. Ignore Duplicates and Create New List of Unique Values in Excel
  13. Find last used cell in Excel VBA
  14. Excel Date to String conversion
  15. Excel: Formulas for converting data among column / row / matrix
  16. Excel: Searching for multiple terms in a cell
  17. Three Dimensional Lookup Using INDEX/MATCH
  18. Optimizing Excel formulas – SUMPRODUCT vs SUMIFS/COUNTIFS
  19. Comparing two columns, and returning a specific adjacent cell in Excel
  20. Countif With Multiple OR Criteria
  21. Dynamic chart range using INDIRECT: That function is not valid (despite range highlighted)
  22. Convert from US to UK format
  23. excel vlookup with multiple results
  24. How to roundup a number to the closest ten?
  25. Convert an Array Formula’s Text Results into a Usable Format
  26. Date-Formatting in TEXT formula independent from used language in Excel
  27. Can’t pass a range to a lambda using Let and Makearray functions
  28. Check whether a cell contains a substring
  29. Unique Rank value for a subgroup within a group
  30. Get content of a cell given the row and column numbers

Leave a Comment