Require a formula for getting a specific text from the table

Dear friends

I require a formula for getting a specific text from the table. When I Enter the emp code, the term staus has to come in the concerned box. (For ex: when emp code 1 is given, the term starting cloumn status 'poor' should come at the concerned box). For Breif details please go through the details and give a solution.

Emp Code - 1


Term Starting Status poor

Term 2 Status

Term 3 Status

Term 4 Status

Table:

Emp Code Name Term Term Status
1 AAAAAAAAAA Starting Poor
2 BBBBBBBBBB Starting Better
3 CCCCCCCCCCCC Starting Outstanding
4 DDDDDDDDDD Starting Good
1 AAAAAAAAAA 2 Outstanding
2 BBBBBBBBBB 2 Poor
3 CCCCCCCCCCCC 2 Better
4 DDDDDDDDDD 2 Good
1 AAAAAAAAAA 3 Poor
2 BBBBBBBBBB 3 Better
3 CCCCCCCCCCCC 3 Good
4 DDDDDDDDDD 3 Outstanding
1 AAAAAAAAAA 4 Outstanding
2 BBBBBBBBBB 4 Poor
3 CCCCCCCCCCCC 4 Good
4 DDDDDDDDDD 4 Better
1 AAAAAAAAAA 5 Outstanding
2 BBBBBBBBBB 5 Poor
3 CCCCCCCCCCCC 5 Good
4 DDDDDDDDDD 5 Better
1 AAAAAAAAAA 6 Outstanding
2 BBBBBBBBBB 6 Poor
3 CCCCCCCCCCCC 6 Good
4 DDDDDDDDDD 6 Better

thanks in advance!!!!!!!!

Jay

The formula you need to lookup the "code" you entered in cell A2 in a table over in columns E (codes) and column F (status) would be a VLOOKUP formula, like so:

=VLOOKUP($A2, $E:$F, 2, 0)

Adapt that for your actual workbook.