Forum Discussion
how to search in table?
Hi! I want to create a simply calculator for my work.
How do I make a program that will check the protein and urea levels entered by the user and then display recommendations in the “TIP:” field?
Help me! 😭
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))
