Hello all,
I'm having trouble figuring out how to lookup multiple values.
In the attached file, I have a look up in place to return values from the "data" tab based on the date entered in B4 in the "summary" tab.
This works fine and I use this method on a larger scale for other sets of data but I now want to return a sum of values for a range of user selected dates.
On the right hand side of the "summary" tab is pretty much what I'm after. The user will input a from and to date (1-31) and I need a formula that looks up all the data for those dates.
All help greatly appreciated!!
Thanks.
Bookmarks