Forum Discussion

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

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 this possible?:

 InsignificantMinorModerateMajorCatastrophic
Almost CertainMediumHighHighExtremeExtreme
LikelyMediumMediumHighHighExtreme
PossibleLowMediumMediumHighExtreme
UnlikelyLowMediumMediumHighHigh *
RareLowLowMediumMediumHigh *

Thanks for any help :)

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    Hi Karen

     

    That should be something like:

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

     

Resources