Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Copy value from another sheet based on date

Copper Contributor

I have two sheets in a file, one is current, the other one is list of all historical data entered before, containing date/name/amount/price....etc. The same item could have multiple dates on the historical date sheet.

How do  I set it up so that when I enter partial item name in the current cell on current sheet, it will auto-find the value on the other sheet, with latest date on the other sheet?

1 Reply



You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.