Forum Discussion
HansVogelaar
Sep 14, 2024MVP
Like this:
Formula in J9:
=INDEX($I$3:$K$5; XMATCH(I8; $H$3:$H$5); XMATCH(J8; $I$2:$K$2))
=INDEKS($I$3:$K$5; X.DOPASUJ(I8; $H$3:$H$5); X.DOPASUJ(J8; $I$2:$K$2))
Like this:
Formula in J9:
=INDEX($I$3:$K$5; XMATCH(I8; $H$3:$H$5); XMATCH(J8; $I$2:$K$2))
=INDEKS($I$3:$K$5; X.DOPASUJ(I8; $H$3:$H$5); X.DOPASUJ(J8; $I$2:$K$2))