3 Replies Latest reply: Oct 13, 2012 8:09 AM by Cesare Bellotti RSS

    expression similar to vlookup or something different?

      Hi All,

       

      I’m very new and I need a quick help, I hope.

      I need to make an expression similar to excel vlookup. I need to multiply working “hours” for  “rates”, where rates depend on “who “ spent the hours working.

      At first I believe I succeeded but then I see that totals don’t work. I guess there is some “logical” mistake but I don’t understand where is it.

      Can you help me?

      I attach an example file.

       

      ..second.. what is the best way to learn expression? Is there somewhere a list of example of most used  an useful ones?

       

      Thank you in advance

      Sisar