EXCEL FORMULA HELP PLEASE

%3CLINGO-SUB%20id%3D%22lingo-sub-2300081%22%20slang%3D%22en-US%22%3EEXCEL%20FORMULA%20HELP%20PLEASE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2300081%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20am%20stuck%20with%20a%20formula.%20I%20have%202%20data%20sets%20with%20date%20ranges.%20I%20am%20trying%20IF%20statements%20and%20INDEX%20MATCH%20statements%20and%20none%20seem%20to%20be%20returning%20the%20data%20I'm%20looking%20for.%20The%20first%20sheet%20for%20example%20has%2C%20apples%20sold%3A%2030%20units%20between%201%2F01%2F2021%20-%201%2F07%2F2021%2015%20units%20between%201%2F08%2F2021%20-%201%2F14%2F2021%2010%20units%20between%201%2F15%2F2021%20-%201%2F21%2F2021%20The%20second%20sheet%20shows%20apples%20was%20on%20promotion%20%23123%2C%20between%201%2F05%2F2021%20-1%2F10%2F2021.%20I%20need%20the%20promotion%20%23123%20to%20return%20its%20value%20in%20the%20first%20sheet.%20Can%20you%20please%20help%20me%3F%20I%20don't%20even%20know%20which%20formula%20I%20need%20to%20google%20to%20figure%20this%20out%20for%20myself.%20Thank%20you!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2302397%22%20slang%3D%22en-US%22%3ERe%3A%20EXCEL%20FORMULA%20HELP%20PLEASE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2302397%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1038929%22%20target%3D%22_blank%22%3E%40Dble_elle%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20better%20to%20ask%20Excel%20community%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fbd-p%2FExcelGeneral%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fbd-p%2FExcelGeneral%3C%2FA%3E%26nbsp%3Bdesirably%20with%20small%20sample%20file.%20It%20could%20be%20lot%20of%20reasons%20-%20texts%20as%20dates%20(not%20actual%20dates)%2C%20wrong%20using%20of%20formula%2C%20wrong%20formula%2C%20etc.%20And%20it%20depends%20on%20how%20your%20data%20is%20structured.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2302445%22%20slang%3D%22en-US%22%3ERe%3A%20EXCEL%20FORMULA%20HELP%20PLEASE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2302445%22%20slang%3D%22en-US%22%3Eok%2C%20thank%20you!%3C%2FLINGO-BODY%3E
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

@Dble_elle 

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.