If Yes then...
 

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

If Yes then...
 

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

If Yes then...
 

Hi NickHK

Might help if I spell out the exact situation...

The information being imported into the spreadsheet comes from a database
that contains applications for scholarships that have been completed online.

Where students answer a question affirmatively on their application we will
require documentary evidence to support their claims. So, when we prepare
their letter of offer I need to be able to mail merge from the spreadsheet
and have the correct listing of documentary evidence appear.

I was thinking if I can jig the spreadsheet so that if a student answered
YES to one of these categories, a corresponding cell would fill with the
appropriate text regarding what documentary evidence is required for that
item.

Then when I do a mail merge, I can make the merge pick up all the 'evidence'
cells so that we don't have to individually review each letter to ensure
they're being asked for the correct info.

Sorry for the long winded reply... Hope it helps a bit.

Regards

castorandpollux

"NickHK" wrote:

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

If Yes then...
 

Assuming another sheet with a range (or named range is easier, called eg
DocEvidence) that contain the "documentary evidence" text that you wish to
show, then
So, where ever you decided to put the info, that cell would contain
something like:
"Passport, Identity Document"
or whatever.
Then, fill down column BG with:

=IF(UPPER(Z1)="YES",DocEvidence,"")

Is that what you mean ?

NickHK

"CastorandPollux" wrote in message
...
Hi NickHK

Might help if I spell out the exact situation...

The information being imported into the spreadsheet comes from a database
that contains applications for scholarships that have been completed
online.

Where students answer a question affirmatively on their application we
will
require documentary evidence to support their claims. So, when we prepare
their letter of offer I need to be able to mail merge from the spreadsheet
and have the correct listing of documentary evidence appear.

I was thinking if I can jig the spreadsheet so that if a student answered
YES to one of these categories, a corresponding cell would fill with the
appropriate text regarding what documentary evidence is required for that
item.

Then when I do a mail merge, I can make the merge pick up all the
'evidence'
cells so that we don't have to individually review each letter to ensure
they're being asked for the correct info.

Sorry for the long winded reply... Hope it helps a bit.

Regards

castorandpollux

"NickHK" wrote:

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