Jul 14 2022 08:29 PM
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?
Jul 15 2022 12:14 AM
=LARGE(IF(NOT(ISBLANK(B3))*ISNUMBER(SEARCH(current!B3,historical!$C$3:$C$26)),historical!$B$3:$B$26),1)
You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.