I am trying to get the next matched date from one column to the next.
So far I have tried getting the minimum of col F, =MIN(F2:F60) .
Now In another sheet in column D, I want to match this and if I cant match find the closet previous date.
In the below my last date is 11-Sep-2018, So I want to look into another column and return 11-Sept-2018 or the closet previous date, which could be anything before sept 11.
dont mind the duplicates.
Answer
Use VLOOKUP
=VLOOKUP(MIN(F2:F60),Sheet2!D:D,1,TRUE)
No comments:
Post a Comment