Hello,

I need help making a shorter formula of this one:

=IF(C3="Presiune Nominala";Values!E3;IF(C3="Presiune Mare";Values!F3;IF(C3="Presiune Mica";Values!G3;IF(C3="Temperatura Nominala";Values!B3;IF(C3="Temperatura Mare";Values!C3;IF(C3="Temperatura Mica";Values!D3;IF(C3="Debit Normal";Values!H3;IF(C3="Debit Mare";Values!I3;IF(C3="Debit Mic";Values!J3;0)))))))))


Values! represents a different page.

I am a beginner in excel..

Thanks