Return last value of a row based on another value

[PGD15]

Hi,

I have written the following formula:

=INDEX('Daily Breakdown'!AD1:AD1000,COUNTIF(('Daily Breakdown'!AD1:AD1000),"<>0"))

this returns the last value in column AD which is not 0.

However I want this to return the bottom/last value based on the value in column B

So if column B is equal to certain value in a different tab then throughout range AD1:AD1000 return the last value if this is true.

So i kinda want to do index(AD1:AD1000,Match('Monthly Summary Tab'B21,B3:B100),0)*/(COUNTIF(('Daily Breakdown'!AD1:AD1000),"<>0")),1)

Though that doesn't work but that kind of thing. hope that makes sense ....


Just to clarify i wish to return the last value in the ad (Monthly tab) column if the range in cell b3:b100 (monthly tab) is equal to that of the value in B21 (daily tab) AND the value is not equal to 0.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1060251-need-help-adapting-formula.html#post5091571

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).