vlookup adapation

[PGD15]

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

 

[Legacy 143009]

A small update:
=IF(VLOOKUP(B21,'Daily Breakdown'!$A$2:$AV$154,29,TRUE)=0,INDEX('Daily Breakdown'!$A$2:$A$154,MATCH(B21,'Daily Breakdown'!$AC$2:$AC$154>VLOOKUP(B21,'Daily Breakdown'!$A$2:$AV$154,29,TRUE),0)),VLOOKUP(B21,'Daily Breakdown'!$A$2:$AV$154,29,TRUE))

 

[PGD15]

um, we're almost there :')

Currently the formula returns the correct value if the last cell in the target range of AC is populated however if this equals 0 or "" this returns the value in column A, i tried adapting the formula from A2:a154 to AC2:ac154 as i think you used the wrong range but then this formula returns the heading... so i changed the ranges to AC3 (top row with a value) then get the message of #na .

I think i must have changed something incorrectly

Edit:

I got the formula to return a value now! issue is ... its the top value (darn it) so i tried changing the true's and false and can either make it return the bottom value (with a 0, not what i want) or the top value which is also not what I want :'(

its effectively doing the simple vlooup(b21,'Daily Breakdown'a2:av154,29,false) still :'(

returns top value:
=IF(VLOOKUP(B21,'Daily Breakdown'!$A$2:$AV$154,29,TRUE)=0,INDEX('Daily Breakdown'!$AC$3:$AC$154,MATCH(FALSE,'Daily Breakdown'!$AC$3:$AC$154>VLOOKUP(B21,'Daily Breakdown'!$A$2:$AV$154,29,FALSE),0)),VLOOKUP(B21,'Daily Breakdown'!$A$2:$AV$154,29,TRUE))

Returns bottom value:
=IF(VLOOKUP(B21,'Daily Breakdown'!$A$2:$AV$154,29,False)=0,INDEX('Daily Breakdown'!$AC$3:$AC$154,MATCH(FALSE,'Daily Breakdown'!$AC$3:$AC$154>VLOOKUP(B21,'Daily Breakdown'!$A$2:$AV$154,29,FALSE),0)),VLOOKUP(B21,'Daily Breakdown'!$A$2:$AV$154,29,False))

 

[PGD15]

Solved my Problem! Thanks for the help, Much appreciated!