How do I enter 'response contingent' text?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I have developed a test in an excel sheet. There is a column where people
indicate their answer for each question (from 1 to 5), I want to be able to
import text from another sheet (within the same file) that is specific to
persons scores on each question (i.e those that score 1 will have a sentence
imported, those that score 5 will have a differenct sentence imported) to
generate an overall test report.
Hope this doesn't sound too confusing!
Thanks in advance for your help :)
 
construct a table somewhere with 1 thru 5 in a column, and th
corresponding sentences in the next column, then reference this with
vlookup function
 
Back
Top