lookup not in row but in matrix

F

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...


??????????
 
F

Frank Kabel

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