I'm drawing a blank here. I have two columns in Excel, B5:C50. In B there is a validation drop box with a series of numbers. When the user selects one of the numbers, i want C to display a specific word. For instance, if the user goes to B5 and selects the number 2, C5 should display "example".
I just can't remember how to do this. Any suggestions?
Thanks.