Extract text from a table

[StarMusk10]

Hello,
I would like to extract text from a table based on criteria. I have attached a sample workbook for you to view. In my workbook I have a data table containing unit names, quarters and positive and negative comments. Based on the selection from the drop down lists I would like the positive and negative comments to populate in H4 and H5. I have no issue if these were numbers, but I can't seem to figure out how to extract text. Any help would be greatly appreciated.

 

[bosco_yip]

This is a 2 way multiple conditional Lookup question

Sumproduct is one of the Mathematical function, work for numeric result value only.

Lookup function, work for numeric+Text result valve.

So,

In H4, formula copied down :

=INDEX(Data,MATCH(1,INDEX((Unit=H$2)*(Qrt=H$3),0),0),MATCH($G4,Measure,0))

Regards
Bosco

 

[StarMusk10]

This is a 2 way multiple conditional Lookup question

Sumproduct is one of the Mathematical function, work for numeric result value only.

Lookup function, work for numeric+Text result valve.

So,

In H4, formula copied down :

=INDEX(Data,MATCH(1,INDEX((Unit=H$2)*(Qrt=H$3),0),0),MATCH($G4,Measure,0))

Regards
Bosco

Thank you bosco_yip! I had been struggling for a few days with this.