Updating cell data from a table with an ID
 

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? :)

Updating cell data from a table with an ID
 

Use VLOOKUP:

Assume DV is in cell A2 and price in B2:

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

HTH

"MadHenry" wrote:

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? :)