Lookup most recent data point ignoring zeros and blank cells

[Krucial155]

I currently have a metric spreadsheet that is updated daily. After I put in the data, I have a function to calculate the sum and percentages of certain metrics.

I currently have a lookup function that I use for some input fields to ignore the blank cells and only return the last cell with numeric value (which will be the most recent day's data). However, when I try to use this for different metrics to pull onto another sheet, it is taking the 0s from this row. How can I have a lookup function that ignores blank cells, and ignores zeros, but still pulls the most data.

=LOOKUP(2,1/(3:3<>""),3:3)

That is the function I found for my input field. It allows us to pull the most recent cell (total followers) excluding cells in that row that are blank.

I'm very new to Excel and self-taught myself over the course of the past 2 weeks. I would love to get some guidance on how to accomplish my goal of eliminating Zeros from the lookup as well, but also understanding the function part by part, should somebody have the time.

Thank you.

 

[jasonb75]

Oops, I knew what I was trying to do but looks like I made a bit of a mess of it

=LOOKUP(2,1/((1/(1/$A3:$Z3))<>-100%),$A3:$Z3)

Tested this time to make sure it works

 

[Krucial155]

Oops, I knew what I was trying to do but looks like I made a bit of a mess of it

=LOOKUP(2,1/((1/(1/$A3:$Z3))<>-100%),$A3:$Z3)

Tested this time to make sure it works

Thank you so much Jason.