Two Things: Depended Dropdowns and LOOKUP Function

[OfficeMan81]

I trying to create an Excel spreadsheet that has two dropdowns and an area that displays some information based on what is selected.


If Dropdown 1 is X and Dropdown 2 is X show this text.


Any suggestions? Thanks

 

[Luke M]

Making some major assumptions about the layout of your lookup table, you could use this array formula (Ctrl+Shift+Enter to confirm):

=INDEX(C:C,MIN(IF((A1:A100=Dropdown1)*(B1:B100=Dropdown2),Row(A1:A100))))


Otherwise, we need more info about how your lookup table is structured.

 

[OfficeMan81]

Thanks for the reply.


I have a list of responses for a call center. If a woman calls (Dropdown 1) and the complaint is X (Dropdown 2) then use one of these responses. I will have 4 sections that display different resolutions.


Do this help?

 

[Luke M]

Could you post an example of your workbook?

 

[Kyrre]

I trying to c/quote]

http://chandoo.org/forum/threads/drop-down-lists.14876/#post-89127