I am attempting to write a formula that will help pull data from column D into column H (currently populated but would be blank).
Logic is as follows: If any of the IDs in column A are in the range of column F and G2 is within the date range of B2 and C2, then give me the data from column D into H.
If ID's match and the date in question falls between or is equal to the date range for the matching ID, then pull the corresponding data in column D.