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?
--
many thanks,
Sally

Hi Sally

Take a look at Debra Dalgleish's site
http://www.contextures.com/xlDataVal02.html

--
Regards

Roger Govier


"v&sr4JC" wrote in message
...
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?
--
many thanks,
Sally

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)

v&sr4JC wrote:
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?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html