1 Reply Latest reply: Dec 11, 2012 5:50 AM by gidon david RSS

    find data from a file

    gidon david


      attached a excel file


      first sheet is data :


      part is the  part number

      date is the date of the transaction

      inx is the line no for same date

      cost is the item cost


      second sheet is  item :


      there is a list of items , and dates

      I need to bring the cost  of the part

      from the nearest date  from the data file 


      in many cases there is no cost  for the part on the day required


      i hope you can help