ExcelBanter - How do I add a "code" to a value?

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I add a "code" to a value? (https://www.excelbanter.com/excel-worksheet-functions/67442-how-do-i-add-code-value.html)

Dalene

How do I add a "code" to a value?

Hi,
I need to create 11 codes with a value added to each. I mainley work in
Exel. When I enter the code in a cell I need the value to reflect in that
cell. Can someone please assist me?

All times are GMT +1. The time now is 11:57 PM.