Excel codes

[kimkainina]

Hello! I would like to know about personalized codes or whatever it is called hehe... for example,

If I introduce "600" in the cell, automatically there will be a text saying "purchase".

What should I do to make like a legend of numbers/personalized codes which correspond to a specific text?

Thank you so much!

 

[Joe4]

Welcome to the Board!

If you create a lookup table, you can use VLOOKUP to do what you want.
See: https://exceljet.net/excel-functions/excel-vlookup-function

 

[kimkainina]

Welcome to the Board!

If you create a lookup table, you can use VLOOKUP to do what you want.
See: https://exceljet.net/excel-functions/excel-vlookup-function

Thanks so much!!!!

 

[Joe4]

You are welcome!