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