Em Andamento

List filter and selection in Excel

I would like to have several drop down menus setup in Excel and the first drop down menu will filter the other drop down menus. I also want to be able to reference the selected values in each drop down menu in a vlookup or match/index formula.

The data table for the drop down menus will be variable.

## Deliverables

I've attached a sample data set to use where there will be 4 drop down menus "Equipment", "Capacity", "Power", "Antenna". The user will use a drop down menu to select the equipment and the subsequent drop down lists will be filtered by choice of equipment (information identified in the row of the equipment).

The capacity, power, and antenna selections will have a cost associated with each item and I need that to be summed.

Habilidades: Engenharia, Excel, Microsoft Access, Microsoft Exchange, MySQL, PHP, Powerpoint, Gestão de projetos, Arquitetura de software, Teste de Software, Word

Ver mais: excel selection list, excel filter list, excel drop list filter, power user excel, match management, match list, first choice power, vlookup table, excel power user, Vlookup, selection, filter, excel vlookup, excel formula, data set formula, formula excel index, excel project vlookup, excel match formula, php drop list, menu filter, data table excel, excel filter table, index match formula, excel table 2010, drop list php

Acerca do Empregador:
( 4 comentários ) Canada

ID do Projeto: #3066573

Premiar a:

idealsolutionvw

See private message.

$34 USD em 1 dia
(105 Avaliações)
5.5

5 freelancers estão ofertando em média $45 para este trabalho

shikhamehta

See private message.

$46.75 USD em 1 dia
(210 Comentários)
6.9
nikitasvw

See private message.

$29.75 USD em 1 dia
(73 Comentários)
4.5
vw7437936vw

See private message.

$42.5 USD em 1 dia
(19 Comentários)
4.1
vw7421755vw

See private message.

$72.25 USD em 1 dia
(1 Comentário)
0.0