Help returning earliest date


I have 2 sheets collecting data, both sheets use a unique PRF reference number (which I use for match purposes), I need the look up to return the earliest date from the Book 1 Range 1 data, where the PRF numbers match more than once on the sheet. Currently it will only return the first option it finds, as you can see I added the MIN argument but not something I have used before, so unlikely in the correct argument point in the formula

=MIN(INDEX({Book1 Range 1}, MATCH([PRF Auto Number]@row, {Book1 Range 2}, 0)))




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!