Thread: How can I give text (A,B...) a number value in Excel (A=1, B=2..)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete Pete is offline
external usenet poster
  
Posts: 193
Default How can I give text (A,B...) a number value in Excel (A=1, B=2..)
I'm trying to give a word/text a numeric value. High = 3, Medium = 2 and Low
= 1 etc.

I thought this could be done with a lookup table? If anyone has any
information on how to do this I'd be most appreciative.

Cheers,

Pete
Reply With QuoteReply With Quote