ExcelBanter - Convert text to numeric value

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Convert text to numeric value (https://www.excelbanter.com/excel-discussion-misc-queries/187506-convert-text-numeric-value.html)

Dylan @ UAFC

Convert text to numeric value

I wan to be able to convert a test code in one colum to
= a numeric value in another cell.
For example
PNI is a code that represent a value of $20.00
PS is a code that represents a value of $10.00
Ps would be entered into A1 and then converted to numeric value in cell f1
Please advise

Gord Dibben

Convert text to numeric value

Entered in F1

=LOOKUP(A1,{"PNI","PS"},{20,10})

Gord Dibben MS Excel MVP

On Wed, 14 May 2008 16:21:00 -0700, Dylan @ UAFC <Dylan @ UAFC
@discussions.microsoft.com wrote:

I wan to be able to convert a test code in one colum to
= a numeric value in another cell.
For example
PNI is a code that represent a value of $20.00
PS is a code that represents a value of $10.00
Ps would be entered into A1 and then converted to numeric value in cell f1
Please advise

All times are GMT +1. The time now is 02:34 PM.