Too many IFs

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
image description
image description


It would probably be easier to understand your problem if you were to upload an actual spreadsheet rather than images; however perhaps you might find VLOOKUP more useful than a string of IF statements??

Try to just get rid of the blank cells in the first sheet, fill them with data. After that, the search will become simple and easy - you do not need IF(), most likely SUMPRODUCT() alone will be enough.

Yes, you’re right. I have attached the file. It’s a calculator which is supposed to input automatically a number of LED stripes needed for a certain size. number for LED stripes are prepared in the worksheet ‘LED’. Now, if A3 equals LED.1:1 then it should put in the value of the third row. For exmple if A3 equals 45(which is LED.G1), then the value should be inserted from the LED.G2.

Excuse me a poor explanation, but I am quite new in the excel/calc.

HLOOKUP() is your friend.

This might work:
=HLOOKUP( $A$3 ; $LED.$B$1:$JB$2 ; 2 ; 1 )

Thank you kind sir!