I'm trying to create a formula which will in the absence of data for itself, reference a column for the first piece of numeric data. However, I'm not sure what formula I should be using. Below is a screenshot and link to create your own iteration of my sheet.

enter image description here

I've highlighted "???" in this formula thinking that perhaps I can solve this with a VLOOKUP formula, but perhaps I'm wrong. As a means to test this out, one of the cells towards the bottom is referencing the "600" value on the left.


I don't know if I'm explaining this well or not, but essentially what I'd like to do is have it so that if a person decides to enter their weight and they don't start on December 26th, the value that shows up for December 26th is the first numeric value they enter for the year.

Thanks everyone!

1 Answer 1


It looks like the function needed here was “SORTN” (as pictured below). This allowed the first numeric value to be returned, which in this case was 600. I tested this by adding more data to the two leftmost columns and whatever showed up first in Column D was the value returned.

In this case, the new formula for that specific section should be “SORTN(D4:D373,1)”.

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.