• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel formula to get Value lookup by date range

deenoseban

New Member
Trying to fix a formula. In the master table there a few items for which the price will change according market. In the working sheet, based on date item value should be picked.
If somebody has an idea please update.
Lookup by Date range.jpg
 

Attachments

  • Value lookup by date range.xlsx
    10.5 KB · Views: 6
how about
=INDEX($B$3:$B$14,MATCH(F3,IF($A$3:$A$14=G3,$C$3:$C$14),1))
 

Attachments

  • Value based on criteria and nearest date.xlsx
    11.3 KB · Views: 9
Back
Top