Hi

I am aiming to use a set date in sheet A lets say cell B3 to select data from another sheet B in which has a series of date ranges in C3 to D3 and a value needed in E5, C4 to D4 and a value needed in E4, etc.

How would I do that