Row 1 Col A Col B
Row 2 Presence Response
Row3 None no response
Row 4 some be watchful
Row 5 moderate consider action
Row 6 severe implement action
In the above each item in col b is logically related counter part on Col A
In cell D1 one of the items in Col A will be present (any one of the text items may be present)
In cell E1 I want the logically related text from Col B to whatever text from Col A may be present to automatically post.
So if Col A Row 3 is present in D1 I want the text from Col B 3 to post to E1 and the same for any specific text that might be present in D1.
Ant help with a formula in D1 to accomplish this would be greatly appreciated.
Row 2 Presence Response
Row3 None no response
Row 4 some be watchful
Row 5 moderate consider action
Row 6 severe implement action
In the above each item in col b is logically related counter part on Col A
In cell D1 one of the items in Col A will be present (any one of the text items may be present)
In cell E1 I want the logically related text from Col B to whatever text from Col A may be present to automatically post.
So if Col A Row 3 is present in D1 I want the text from Col B 3 to post to E1 and the same for any specific text that might be present in D1.
Ant help with a formula in D1 to accomplish this would be greatly appreciated.