How to make a linked drop down list with prices?

Question

excel

How to make a number appear in another cell when selecting products from the list?

spoiler

Answer 1

Something like this:
=еслиошибка(впр(i8;a:g;7;0))