4 Replies Latest reply: Jan 5, 2013 11:09 AM by gidon david RSS

    filter items from a table

    gidon david

      Hello

      I need your help if possible  to filter items from a table

      I have 2 tables ( enclosed ) 

      first is ITEMS where the is items , qty , price  - SHEET ITEMS

      second file listitems  contain the parts that I need   to filter  - sheet list

      the problem is that i get only the first few characters from the item

      like 12*  or 17*  as shown in the file listitems 

       

      I need to create a table that will contain the line from the items table 

      where the items starts as shown in the listitems

       

      the result should look like as shown

      in file ITEMS sheet result

       

      thanks for your help

      gidon