Cell B1 has a code and Cell B2 has that code's description. I need a function in column A that will reference column B and say if B1 is a code then "value", if B2 is a text then "description".
For example: B1 - 140109
B2 - Aluminum Powder
then A1 should say - "value" and A2 should say "description