Trying to Combine 2 Formulas

[meppwc]

I cannot get the result that I am looking for and I am guessing that I have the parenthesis incorrect.

The formula below works correctly
=IFERROR(VLOOKUP(A721,Available!A:A,1,FALSE),"")

But I want to add another condition that the formula looks at first
=IF(Available!C5<1,"")

So if C5<1 then the cell will be blank...........but if C5 equals or is greater than 1, then this formula runs.........=IFERROR(VLOOKUP(A721,Available!A:A,1,FALSE),"")

What I currently have that is NOT working correctly is below
=IF(Available!C5<1,"")*(IFERROR(VLOOKUP(A722,Available!A:A,1,FALSE),""))
It returns #VALUE !

 

[hotabae]

Instead of using the "*" , You need to follow the =IF formula syntax which is =IF(logical_test,value_if_true,value_if_false) , and treat the 2nd formula as your "value_if_false"//else condition.

In your case the two formulas would combine to this:

=IF(Available!C5<1,"",IFERROR(VLOOKUP(A721,Available!A:A,1,FALSE),"")

 

[Scott T]

Try

=IF(C5<1,"",IFERROR(VLOOKUP(A721,Available!A:A,1,FALSE),""))

 

[meppwc]

Thank you so much