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

Veja 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

Concedido a:


See private message.

$34 USD em 1 dia
(105 Comentários)

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


See private message.

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

See private message.

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

See private message.

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

See private message.

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