Hi, I am having some trouble with the attached formula. Can anyone help?
Vlookup formula with date conditions
-
-
Not from an image, you need to attach an example workbook.
-
This looks very similar to the following article:
-
In C9, enter formula :
=LOOKUP(9^9,B3:B5/(A3:A5=A9)/(C3:C5<=B9)/(D3:D5>=B9))