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

    find data from a file

    gidon david

      hello

      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

       

      gidon