I am sorry, here I am again with another question.

Everything is the same, except that I want to use a dropdown list instead of "Name" in A2 (SheetInvoice)

Now here it comes:

-----------------------------------------------
Suppose that given:

Sheet 1 - List of Description

C1 = Name (C2 to C20 )
D1 = Description (D2 to D20)
E1 = Price (E2 to E20)

fe. Watch (C2) Cartier Watch Design from 2009 (D2) 500,000 Dollar (E1)


and I want to automatically use sheet 2 for the invoice

Sheet 2 - Invoice

This time I want to make A10 to A30 a dropdown list. The dropdown list is the list from the 1st sheet (Name)

Is it possible to automatically put the matching description and price in B10 and C10 (when you choose a random item in the dropdown list)?

Thank you