I need help to look for nearest date (Min, Max) available in sheet2 for the given date sheet1 and applicable variable(Apple). (similar to lookup but in this case exat date doesn't match).
<tbody>
Sheet1
A
B
RESULT()
Expected Result
1
Name
DATE
Nearest min date
Nearest...