C & P,
Depends somewhat where this "specific text" is coming from and how/if it
varies with that entry.
More details.

However something like this in BG1 may get you started:
=IF(UPPER(Z1)="YES","Has Citizenship","Nope")
although this does nothing much different from the current Yes/No, you can
see how to test and branch.

NickHK

"CastorandPollux" wrote in message
...
Hi

I'm a total novice with excel and need to be able to do the following:

I have a spreadsheet whose data has been extracted from an external
database. Some of the columns contain either YES/NO or specific numeric
values. For each cell in a row that holds a YES or the required numeric
value, I need to be able to have a new cell at the end of the row
automatically fill with information. For example:

Column Z contains information on citizenship (either YES or NO) for each
person.
Where the answer is YES, I need the corresponding cell in Column BG to
display specific text.

Hope I haven't confused you all with my roundabout explanation. All help
or
suggestions are most appreciated.

Thanks
castorandpollux