I have a spreadsheet that has drop down values in columns D and E (use can select high or low). Based on what is selected in those two columns I want to automatically populate text in column F.
Here are a couple of specific examples:
When D and E are both Low then F should be populated with the words Monitor (Low Interest, Low Authority)
When D and E are High and Low then F should be populated with the words Keep Informed (High Interest, Low Authority)
I only have 4 permutations of this.
Thanks for any help you can provide.
Kate
Bookmarks