lookup not in row but in matrix

[frens]

Frank,

I cannot work out your proposal.
INDEX may need two arguments, for a start.
And IF(range="x" ... does not work for me...


??????????

 

[Frank Kabel]

Hi
what formula have you entered?
Also make sure you enter it as array formula