Updating cell data from a table with an ID

[Guest]

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?

 

[Guest]

Use VLOOKUP:

Assume DV is in cell A2 and price in B2:

in B2: =VLOOKUP(A2,hinnakiri,2,0)

HTH