# Lookup most recent data point ignoring zeros and blank cells

#### Krucial155

##### New Member
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

##### Well-known Member
Oops, I knew what I was trying to do but looks like I made a bit of a mess of it
Excel Formula:
=LOOKUP(2,1/((1/(1/\$A3:\$Z3))<>-100%),\$A3:\$Z3)
Tested this time to make sure it works

### Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

#### Krucial155

##### New Member
Oops, I knew what I was trying to do but looks like I made a bit of a mess of it
Excel Formula:
=LOOKUP(2,1/((1/(1/\$A3:\$Z3))<>-100%),\$A3:\$Z3)
Tested this time to make sure it works
Thank you so much Jason.

Replies
0
Views
202
Replies
9
Views
360
Replies
8
Views
147
Replies
1
Views
336
Replies
1
Views
65

1,127,197
Messages
5,623,308
Members
415,965
Latest member
Sixaside

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back