2 Replies Latest reply: Jan 2, 2015 2:04 PM by Massimo Grossi RSS

    Advanced search between two tables

      Hi,

       

      I'd like to ask you if you have any idea how to search values from Table1 into descriptions from Table2 and match them.

       

      In Table2 in texts appear products form Table1.

       

      How to match them?

       

      Of course without copying and pasting values into search box for example: *Product No1* .

       

      Something like look up function?

       

      For example:

       

      Table1:

      Product No1

      Product No2

      Product No3

      Product No4

       

       

      Table2:

      I love Product No2

      I am interested in Product No1 but I am not sure

      Does anyone know if Product No2 is better than Product No4

      Product No3 that's it!

      Product No1 I'd like to buy