Auto Populate a Cell Based on a Phrase

[Krames]

Hey all:

I need help figuring out how to auto populate a cell based on a phrase or text in another. So, for example:

If I put 'Replace VCT in doorway' in A1, I would like 'TWO' to automatically appear in B1.

Would it be easier for me to do this in Access and then export it to excel? Either way, if someone could point me in the right direction, I would be very grateful!

Thanks!

 

[Krames]

To be clear, I would like the phrase 'VCT' in the example to generate 'TWO'
Sorry for the double post.