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!