Forum Discussion
I need help to find a formula that return value related within a given range of time.
Hi Gina,
As a variant you may use array formula (Ctrl+Shift+Enter) like
=IFERROR(INDEX(B:B,MATCH(1,(YourDate>C:C)*(YourDate<D:D),0)),"No such")
Hi Sergei, thank you for your assistant.
It has not worked, i think I might be missing a step.
If you have the time and you don´t mind, can you access this https://wcs1-my.sharepoint.com/personal/gleite_wcs_org/_layouts/15/guestaccess.aspx?docid=17f47e5cbe1c643e780570716f5486ae1&authkey=AeKH1gHmnQiXHVCtK3pSAdY on excel online to help me out?
Thank you very much !
gina
- SergeiBaklanNov 08, 2017Diamond Contributor
Gina, I'll do bit later, but, yes, such formula won't work in Excel Online if you use it. Will check the file and try to find alternative.
- Gina LeiteNov 08, 2017Copper Contributor
Hi Sergei
I use both Excel online and desktop.
I would be happy to use Excel desktop to solve that problem, so you could download the file and try on our computer :)
many thanks!
Gina
- SergeiBaklanNov 08, 2017Diamond Contributor
Thank you Gina, that will be easier