How to make a simple dropdown list with data in Excel?

R

Rudy9962020-08-24 14:27:01

excel

Rudy996, 2020-08-24 14:27:01

Like a dropdown list so that when an item is selected, there would be a price?

spoiler

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

O

Oleg, 2020-08-24
@Oleg_F

Correctly I understand that the question is in setting the price? In the cell with the price, write the VLOOKUP formula, and take the search value from the cell with the name

Similar questions

D

Denis Kotov2021-02-15 16:30:03

How to open an old x32 Excel file with VBA macros in a new x64 office? 1Reply

V

Viktor S2021-02-16 23:55:21

How to copy a range of cells in Excel that takes data from another sheet so that the addresses do not change? 1Reply

D

Danil O'neil2021-02-17 19:34:02

Excel places the artifacts on top of the cell. What is it and how to remove it? 2Reply

S

skullcowboy2017-02-18 11:13:11

In the Mac version of Excel 2016, the colors of the cells are not copied, only the data in them. How to solve it? 0Reply

G

Grigory Dudnikov2017-02-19 15:49:59

How to map tables one to many? 1Reply

Didn't find what you were looking for?

Ask your question