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

A

asizhuk2019-07-24 18:01:58

nodejs, exceljs. Checking if merged cells intersect horizontally? 0Reply

A

Andrey Demidenko2015-02-23 15:19:51

Which gem to use to parse an excel file into an Active Record object? 1Reply

W

weranda2015-02-27 14:58:35

How to process a large amount of data with the right formatting? 7Reply

S

Sergey2017-03-07 06:06:21

How to get rid of 1s artifacts when copying to Excel? 4Reply

V

Vadim2019-08-12 11:58:09

How to calculate the sum of divided numbers in a column in Excel? 1Reply

Didn't find what you were looking for?

Ask your question