Quote Originally Posted by Azam Ali View Post
Hi Silverscreen

find the attatch file with formula
Hi Azam,

Thanks for help again, it looks good but for cell B3, i only want it to return results from Sheet 2 in column C (matching the dates in the title). i did copy this formula into my sheet using the correct arrays and only selected one column for the value to look for if true. but this didn't seem to work, it returned no numbers

Thanks.