=IF(H5=S6,S10,S11)
H5 is where the dropdown list is,
S6 is Customer
S10 is Customer requirement for...
S11 is Company requirement for...
"Ashish Mathur" wrote:
Hi,
What is your formula.
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Kelly" wrote in message
...
Hi!
I have a dropdown list, using the validation function, with three
responses:
Blank
Customer
Company
In the cell below I want it to come up with the matching response
depending
what is chosen from the dropdown list. So it'll either say:
Nothing
Customer requirement for...
Company requirement for...
I used the IF function and it worked for the customer option but I
couldn't
get it to stay blank when the blank is selected in the dropdown list.
HELP!