Forum Discussion
sethubalaji
May 15, 2026Copper Contributor
Excel Functions
Find attached a matrix, and picture below I select Rare (0.5) in a cell and Modera (8) in another cell, i want function to return in a cell from matrix above. Like A (4) with green filled in. ...
Detlef_Lewin
May 15, 2026Silver Contributor
=INDEX(data,XMATCH(rh,rowheaders),XMATCH(ch,columnheaders))