Ask Your Question
0

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

C:\fakepath\ifs.xlsx

edit retag flag offensive close merge delete

Comments

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
0

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

Comments

Thank you kind sir!

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

Question Tools

1 follower

Stats

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

Seen: 40 times

Last updated: Feb 23