2

this is the problem: I have two worksheets, one that records and discriminates revenues and expenses:

enter image description here

And other that contains a table with the price, revenue and taxes for each product:

enter image description here

Now, I need function that receives the code (or the description name) of a product on the first worksheet and put the values ​​(income, taxes, price) available in the second worksheet, this way: enter image description here

I thought of such a solution, but it gives me a parsing error: enter image description here

So if you can share a little of your intelligence and mental power with me, I'll be grateful until the nex aeon.

craftApprentice
  • 2,697
  • 17
  • 58
  • 86

1 Answers1

2

Have you tried =VLOOKUP(B4,tax_table!A:F,2,FALSE) ?

pnuts
  • 58,317
  • 11
  • 87
  • 139
  • Thanks, @pnuts , Now I'm going to research how make the product code from the other sheet autocomplete. – craftApprentice Jul 26 '13 at 21:08
  • I've already implement fill 'DESCRIPTION' based com 'PRODUCT_COD' (http://stackoverflow.com/questions/17891387/google-script-function-that-insert-new-row-copying-functions-formulas-from-last) But I'd like to type the first letter of the code and have all codes with that letter shown (real codes have letters, not numbers like the sample in the question). Thanks again! – craftApprentice Jul 26 '13 at 21:36