<div>
<div class="content wysiwyg-content">
Hello!<br />
<br />
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 &quot;value&quot;, if B2 is a text then &quot;description&quot;.<br />
<br />
For example: &nbsp;B1 - 140109 <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B2 - &nbsp;Aluminum Powder<br />
<br />
then A1 should say - &quot;value&quot; and A2 should say &quot;description
</div>
</div>


Hello!

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

Function that identifies text as a text and a value as a number

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.