Ask Your Question

Too many IFs

asked 2021-02-23 09:22:09 +0100

kapek1444 gravatar image

updated 2021-02-23 09:53:51 +0100

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


edit retag flag offensive close merge delete


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

robleyd gravatar imagerobleyd ( 2021-02-23 09:41:51 +0100 )edit

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.

JohnSUN gravatar imageJohnSUN ( 2021-02-23 09:48:45 +0100 )edit

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.

kapek1444 gravatar imagekapek1444 ( 2021-02-23 09:54:10 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2021-02-23 10:15:57 +0100

keme gravatar image

updated 2021-02-23 10:16:29 +0100

HLOOKUP() is your friend.

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

edit flag offensive delete link more


Thank you kind sir!

kapek1444 gravatar imagekapek1444 ( 2021-02-23 10:24:58 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2021-02-23 09:22:09 +0100

Seen: 40 times

Last updated: Feb 23