How to get latest value through vlookup in specific dates RRS feed

  • Question

  • hi,

    any body can help me out,

    i am maintaining sheet of daily sales and getting items rate through below list

    for example

    below is the rate of item in two different dates

    Item Rate
    5-Jan-15 Bolt 10
    12-Jan-15 Bolt 20

    below is day by day sales

    Date Item
    5-Jan-15 Bolt
    6-Jan-15 Bolt
    7-Jan-15 Bolt
    8-Jan-15 Bolt
    9-Jan-15 Bolt
    10-Jan-15 Bolt
    11-Jan-15 Bolt
    12-Jan-15 Bolt

    i want to pick previous rate (10) of item till 11-Jan-15 and in same formula wants to get current rate (20) from 12-Jan-15

    Would be great ful.

    My email address is as under



    Thursday, February 5, 2015 5:48 PM