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