Good Morning All,

I have a spreadsheet which contains information about documents. Column D contains the documents revision and column G contains the current document status.

Document revisions are as follows
A1, A2 etc = Internal Review
B1, B2 etc = Client Review
C1 C2 etc = Issued for Use.

I was wondering if I could get Column G to automatically populate with "Internal Review" for example if I entered A(x) into column C - (x being the number of revisions at that status)