Formula doesn't work. What to do?

Question

Google Sheets

Briefly speaking. I have 2 pages(Price List and Operations). The operation page has columns (date, type of operation, product name, article, quantity, purchase price, sale price, profit, percentage). I made it possible to select an article from the drop-down line (1,2,3, etc.). How can I make it so that the name, sale price and purchase price are adjusted automatically depending on the selected article? PS I wrote the formula: =VLOOKUP(D2;'Price List' !A:A; 1;0). The formula doesn't work. Says that opening brackets are missing in the formula, etc. What should I do?

Answer 1

https://docs.google.com/spreadsheets/d/1me0-8VJeY8...