Forum Discussion

Karen Norman's avatar
Karen Norman
Copper Contributor
Sep 07, 2018
Solved

Using a matrix to populate a cell

Hi all   I am trying to calculate the text value of a cell based on the text in two other cells.  Basically I want to use a matrix (see below) of two possibilities to caluculate the third cell.  Is...
excel
Formulas and Functions
  • BobOrrell's avatar
    BobOrrell
    Sep 07, 2018

    Hi Karen,

    Index, Match, Match definitely appears to be the way to go with this one.  Here's an example.  I hope it helps.

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Sep 07, 2018

Hi Karen

 

That should be something like:

=INDEX(data_array,MATCH(row_criteria;row_labels,0),MATCH(column_criteria,column_labels,0))

 

Resources