Thread: CHANGE "C" TO 100 TO FIGURE EXTENDED COST
View Single Post
  #2   Report Post  
Ron Coderre
 
Posts: n/a
Default
This formula will convert the Alpah code to your numeric value:

=VLOOKUP(A1,{"C",100;"M",1000;"E",1},2,0)

Can you fit that into your process?

--
Regards,
Ron
Reply With QuoteReply With Quote