Hi,
I am writting a vlookup:
=VLOOKUP(B21,'Daily Breakdown'!$A$2:$AV$154,29,TRUE)
This formula currently returns the bottom value in column 29. however i want this formula to return the bottom value that is not equal to zero. so i need to try get a <>0 in somewhere but I cannot figure it out.
Can someone please help
I am writting a vlookup:
=VLOOKUP(B21,'Daily Breakdown'!$A$2:$AV$154,29,TRUE)
This formula currently returns the bottom value in column 29. however i want this formula to return the bottom value that is not equal to zero. so i need to try get a <>0 in somewhere but I cannot figure it out.
Can someone please help

Last edited: