how to search in table?

Copper Contributor

dziakrobert20030707_0-1726340828358.png

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! 😭

1 Reply

@dziakrobert20030707 

Like this:

 

HansVogelaar_0-1726341193074.png

 

 

 

 

 

 

 

 

 

 

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