IF formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2172811%22%20slang%3D%22en-US%22%3EIF%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2172811%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20pretty%20new%20to%20Excel%20and%20I%20am%20kinda%20lazy%20and%20that%20is%20what%20my%20problems%20refers%20to.%3C%2FP%3E%3CP%3EI%20am%20using%20an%20common%20IF%20formula%2C%20see%20the%20following%20example%3A%3C%2FP%3E%3CP%3E%3DIF(VLOOKUP(Q%244%3B'Input%20ZUF%20Soll'!%24B%2468%3A%24O%2485%3B3%3BFALSE)%3D0%3B%22%20%22%3B(value%20if%20false))%3C%2FP%3E%3CP%3ENow%20i%20want%20as%20a%20%22value%20if%20false%22%20the%20value%20of%20%22VLOOKUP(Q%244%3B'Input%20ZUF%20Soll'!%24B%2468%3A%24O%2485%3B3%3BFALSE)%22%20without%20using%20this%20entire%20formula%20again.%20So%20I%20want%20an%20expression%20for%20the%20%22value%20if%20false%22%20like%20%22take%20the%20value%20of%20the%20logical%20test%22.%26nbsp%3B%20%22value%20if%20false%22%20is%20required%2C%20so%20if%20I%20just%20don%C2%B4t%20type%20anything%20into%20the%20formula%20it%20is%2C%20not%20surprising%2C%20false.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EThanks%20for%20your%20help%20and%20I%20hope%20you%20understand%20me%3A)%3C%2FP%3E%3CP%3EKind%20regards%3C%2FP%3E%3CP%3EAaron%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2172811%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2172822%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2172822%22%20slang%3D%22en-US%22%3EYou'd%20help%20us%20help%20you%20if%20you%20would%20be%20so%20kind%20as%20to%20post%20a%20copy%20of%20the%20spreadsheet%20in%20which%20you're%20wanting%20this%20%22lazy%22%20formula.%20I'm%20going%20to%20point%20you%20in%20the%20direction%2C%20but%20without%20having%20the%20data%20you're%20working%20with%2C%20I%20can't%20test%20what%20I'm%20suggesting.%20The%20new%20LET%20function%20is%20what%20you%20want.%20Something%20like%20this%20(and%20you%20will%20need%20to%20have%20the%20most%20current%20version%20of%20Excel)%3A%3CBR%20%2F%3E%3DLET(VIF%2CVLOOKUP(Q%244%3B'Input%20ZUF%20Soll'!%24B%2468%3A%24O%2485%3B3%3BFALSE)%3D0%2C.......%3CBR%20%2F%3E%3CBR%20%2F%3EHere%2C%20since%20I'll%20follow%20your%20lead%20and%20be%20lazy%2C%20is%20a%20reference%20that%20might%20help%20you.%20LET%20is%20incredibly%20powerful.%20If%20you%20still%20need%20help%2C%20let%20me%20suggest%20again%20that%20it's%20a%20lot%20easier%20to%20provide%20a%20working%20example%20if%20you'll%20provide%20us%20with%20something%20to%20work%20with.%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fexcel-functions%2Fexcel-let-function%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceljet.net%2Fexcel-functions%2Fexcel-let-function%3C%2FA%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

 

I am pretty new to Excel and I am kinda lazy and that is what my problems refers to.

I am using an common IF formula, see the following example:

=IF(VLOOKUP(Q$4;'Input ZUF Soll'!$B$68:$O$85;3;FALSE)=0;" ";(value if false))

Now i want as a "value if false" the value of "VLOOKUP(Q$4;'Input ZUF Soll'!$B$68:$O$85;3;FALSE)" without using this entire formula again. So I want an expression for the "value if false" like "take the value of the logical test".  "value if false" is required, so if I just don´t type anything into the formula it is, not surprising, false.

Thanks for your help and I hope you understand me:)

Kind regards

Aaron

2 Replies
You'd help us help you if you would be so kind as to post a copy of the spreadsheet in which you're wanting this "lazy" formula. I'm going to point you in the direction, but without having the data you're working with, I can't test what I'm suggesting. The new LET function is what you want. Something like this (and you will need to have the most current version of Excel):
=LET(VIF,VLOOKUP(Q$4;'Input ZUF Soll'!$B$68:$O$85;3;FALSE)=0,.......

Here, since I'll follow your lead and be lazy, is a reference that might help you. LET is incredibly powerful. If you still need help, let me suggest again that it's a lot easier to provide a working example if you'll provide us with something to work with.
https://exceljet.net/excel-functions/excel-let-function

@mathetes 
Thanks a lot, this answer already helped me:) Have a nice week!