0
Basically, I have dates in A, and weights in B. On sheet 2, A1 I have =min(b) which give me the lowest weight in B.
On sheet2 b1 I want to reference the corresponding date for the minimum weight.
I'm very new at excel so i tried to be as specific as possible! Thanks!
In Google spreadsheets you do not have to define the last row, the following would be a valid formula too: =VLOOKUP(A1, Sheet1!$A$1:$B, 1) – ttarchala – 2017-05-07T12:03:36.910
1VLOOKUP goes from A to B, the OP wants to go from B to A, you need INDEX – DavePenn – 2017-05-08T20:42:21.107