How Can I Return a Value by Matching Date Between Date Range in Excel?
How to Look up Date by Date Compared to Dates in Ranges from the Start Date to the End Date? Criteria Are Countries and Delivery Date I Try to Get the Amount...
How to look up date by date compared to dates in ranges from the start date to the end date? criteria are countries and delivery date
I try to get the amount from COL_5 of the table service fee to match with country and delivery date
1 Answer
I assume that the first is column "A",
the formula is an array formula, please use the hold shift before entering
{=INDEX($I$2:$I$10,MATCH(1,(D2>=$K$2:$K$10)*(D2<=$L$2:$L$10),0))}
Sophia analyzes international trade, startup ecosystems, retail transformation, and supply chain logistics for modern digital publications.
