drop down lists

V

v&sr4JC

I have a worksheet that I have three different drop down lists. I want the
users to select one value from each list and after they do so, I want a
response to display, depending on the selections they have chosen. How can I
go about doing this, assuming that it can be done?
 
D

Debra Dalgleish

You could create a table with the possible responses. For example:

Lookup Val1 Val2 Val3 Resp
= B2&"-"&C2&"-"&D2 March Finance Budget Enter a budget amount
= B3&"-"&C3&"-"&D3 March Finance Actual Enter an actual amount

Then, on the sheet with the dropdown lists, enter a formula in another
cell, to return the applicable response, e.g.:

=VLOOKUP(B4&"-"&C4&"-"&D4,Sheet1!$A$2:$E$50,5,0)
 
Top