I have a table called hinnakiri which has a lot of rows and 3 columns with
headers (Material, Price, Other Price)

And I have a column where I can select material name from a DataValidation
drop-down listbox.. I need to update the cell next to it with a price from
hinnakiri.

I need the price to update automatically in that cell every time I change it
in hinnakiri.
How is it possible? :)