# Trying to automatically add text to a cell based on the text values in two adjacent cells

1. ## Trying to automatically add text to a cell based on the text values in two adjacent cells

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.

Kate

2. ## Re: Trying to automatically add text to a cell based on the text values in two adjacent ce

kate try this formula and let me know if it works:

=IF(OR(D1="",E1=""),"",IF(AND(D1="Low",E1="Low"),"Monitor (Low Interest, Low Authority)",IF(AND(D1="High",E1="Low"),"Keep Informed (High Interest, Low Authority)")))

3. ## Re: Trying to automatically add text to a cell based on the text values in two adjacent ce

Could you please attach the worksheet

4. ## Re: Trying to automatically add text to a cell based on the text values in two adjacent ce

I have attached the sample spreadsheet. You can see the 4 options for column F based on what is selected in columns D and E.

5. ## Re: Trying to automatically add text to a cell based on the text values in two adjacent ce

did you try this formula:

=IF(OR(D1="",E1=""),"",IF(AND(D1="Low",E1="Low"),"Monitor (Low Interest, Low Authority)",IF(AND(D1="High",E1="Low"),"Keep Informed (High Interest, Low Authority)")))

6. ## Re: Trying to automatically add text to a cell based on the text values in two adjacent ce

This formula should work:

=IF(OR(D2="",E2=""),"",IF(AND(D2="Low",E2="Low"),"Monitor (Low Interest, Low Authority)",IF(AND(D2="High",E2="Low"),"Keep Informed (High Interest, Low Authority)",IF(AND(D2="Low",E2="High"),"Keep Satisfied (Low Interest, High Authority)",IF(AND(D2="High",E2="High"),"Manage Closely (High Interest, High Authority)")))))

7. ## Re: Trying to automatically add text to a cell based on the text values in two adjacent ce

Thanks. It didn't work for me but it could be operator error. Where do I insert the formula because I must not be doing it correctly. Have you tried it with the spreadsheet that I attached?

8. ## Re: Trying to automatically add text to a cell based on the text values in two adjacent ce

yes just paste it on cell F2

9. ## Re: Trying to automatically add text to a cell based on the text values in two adjacent ce

Yes that's what I tried but it didn't work for me. Is there anything that I need to paste/do in addition to pasting in on cell F2? Were you able to get this to work in the sample spreadsheet I attached?

10. ## Re: Trying to automatically add text to a cell based on the text values in two adjacent ce

Go to Formulas > Calculation Options and see if your calculations are set to Automatic

Yes I tried it in your sheet and it worked.

11. ## Re: Trying to automatically add text to a cell based on the text values in two adjacent ce

Got it now. Thanks so much.

12. ## Re: Trying to automatically add text to a cell based on the text values in two adjacent ce

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1