I am trying to input a word into one cell I want to auto generate the
contents of another cell based on the first input.
I can use Lookup if the first input is a number but this does not seem to
work if the first input is a work or alfa numeric.