Feb 28 2021 11:52 AM
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
Feb 28 2021 12:00 PM
Feb 28 2021 10:42 PM
@mathetes
Thanks a lot, this answer already helped me:) Have a nice week!