Hey There,

I need to find out how can I easily make a formula that will input value from the second sheet. At the moment I have it done the way below, however I need to make 300+ IFs this way… Is there a simplier way?

=IF($A$3=$LED.$B$1;$LED.B2; IF($A$3=$LED.$C$1;$LED.C2; IF