What equation can I write in excel if I want excel to show me an output within certain ranges. Looking at the data table below, if I want excel to show "B" in a cell by typing 5/6/2016 due to the number being between 1/1/15 and 1/1/2020 - I have a long list and not sure how to write the equation or what format to use.
Date Group
1/1/2012 A
1/1/2015 B
1/1/2020 C
1/1/2022 D
| +111 | Is anybody just going to leave the industry? | 36 | 3m |
| +41 | CRE Recruiting for a Career - crazy? | 10 | 2h |
| +31 | Exits from REPE | 16 | 1h |
| +26 | Multifamily firms collpasing in Dallas whose next? | 8 | 2d |
| +21 | Q3/Q4 CRE Job Market Optimism (or lack thereof) | 10 | 1h |
| +19 | Arbor Realty Trust in 2026 | 10 | 19h |
| +18 | LOI Underwriting / Due Diligence | 1 | 21h |
| +15 | NYC Real Estate Job Market | 5 | 2d |
| +14 | Red Flag? Commissions-only acquisitions roles | 7 | 9m |
| +13 | Family Office vs REPE | 9 | 21m |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
I’d use the IFS(…) function. Start with your earliest or latest date e.g. IFS( x > date in cell y, “A”, x > date in cell z, “B”,…)
Thanks! I am familiar with that. If you have a list of 1000 dates, challenging to write all those IFs. Is there another function in excel outside of mutliple nested IFs? Thanks for responding!
Posting the answer here: you’ll want to have the dates in ascending order (earliest first, followed by next chronologically). With corresponding values.
Then you’ll want to run and index (desired values , match (lookup value, ascending dates array, 1)
The 1 in the match function will return the highest date less than your lookup value. You may want to use -1 if you want it to “round up” instead.
Good point. PM me, may have a solution for you.
Thank you! I will try.
Temporibus possimus nostrum corrupti quisquam ipsam enim. Labore ea fuga minus mollitia optio aperiam accusamus. Excepturi placeat et odio. Qui consequatur ipsam et quia soluta.
Enim dolor enim mollitia et. Qui sint ea illum dolorum minus. Commodi voluptatem eum sit qui voluptas.
Cupiditate aspernatur et sint debitis. Quia voluptatem eos illo. Aut eos et cupiditate exercitationem facilis velit. Non praesentium voluptatum modi qui sequi quisquam maiores. Autem nihil modi amet accusantium laudantium ad.
Voluptate quis beatae in. Qui mollitia iure aut porro quo. Iste similique earum voluptas esse et eum qui. Iusto ea rem maxime est magnam labore eum eos.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...