Occasional Contributor

I am stuck with a formula. I have 2 data sets with date ranges. I am trying IF statements and INDEX MATCH statements and none seem to be returning the data I'm looking for. The first sheet for example has, apples sold: 30 units between 1/01/2021 - 1/07/2021 15 units between 1/08/2021 - 1/14/2021 10 units between 1/15/2021 - 1/21/2021 The second sheet shows apples was on promotion #123, between 1/05/2021 -1/10/2021. I need the promotion #123 to return its value in the first sheet. Can you please help me? I don't even know which formula I need to google to figure this out for myself. Thank you!

3 Replies


That's better to ask Excel community here https://techcommunity.microsoft.com/t5/excel/bd-p/ExcelGeneral desirably with small sample file. It could be lot of reasons - texts as dates (not actual dates), wrong using of formula, wrong formula, etc. And it depends on how your data is structured.

ok, thank you!

@Dble_elle Thanks @Sergei Baklan! I'm moving this question to the Excel discussion space which is the appropriate place for Excel questions in the future.