post results on one cell based on contents for another

Rossjp

Board Regular
Joined
Nov 14, 2005
Messages
67
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.
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Watch MrExcel Video

Forum statistics

Threads
1,108,492
Messages
5,523,260
Members
409,506
Latest member
reneekeane

This Week's Hot Topics

Top