I have Cell B1 = 6 on a worksheet named DOC. On Cell B3 of worksheet Week 1 it has "Celina". Is there a way that if Cell B1 in DOC has number 6, Cell B3 on Week 1 will automatically become Celina.

All worksheets are in the same workbook

Likewise if Cell B1 ever has any of the following numbers, cell B3 in Week 1 will display the corresponding alaphnumerics.

1 = Troy
2 = Piqua
3 = Urbana
4 = Grnvl
6 = Celina

Thank You