Formula and Vlookup Help

[dracron]

I have two work sheets where I am using a vlookup to return data (a status to be more specific)

The result could be one of 16 different statuses that we use.

What I would like to do is, based on the status that is returned, it converts to an abbreviation (See below for example)
Right now I am using a run on formula like this:

=IF(VLOOKUP(sheet1!A1,Sheet2!S1:S5,5,false)="Fully Licensed","L",IF(VLOOKUP(sheet1!A1,Sheet2!S1:S5,5,false)="Action Required","A",IF(VLOOKUP(sheet1!A1,Sheet2!S1:S5,5,false)="Pending","p", etc. etc

As you can imagine it is very long.

Is there a way to condense this? I do not want to add an additional column to do another vlookup where it looks at the return result and then vlookup off the status/abbreviation list.
Id like to be contained in one formula.

Status and abbreviation examples:
[TABLE="width: 364"]
<TBODY>[TR]
[TD]Action Required</SPAN>
[/TD]
[TD]AR</SPAN>
[/TD]
[/TR]
[TR]
[TD]Pending</SPAN>
[/TD]
[TD]PN</SPAN>
[/TD]
[/TR]
[TR]
[TD]Scheduled PE</SPAN>
[/TD]
[TD]SE</SPAN>
[/TD]
[/TR]
[TR]
[TD]PE Completed</SPAN>
[/TD]
[TD]PC</SPAN>
[/TD]
[/TR]
[TR]
[TD]Test Scheduled</SPAN>
[/TD]
[TD]T</SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]


Thank you

 

[dracron]

This will do it for you

Do your first vlookup (in bold) which will return the status and then use the table you have the abbreviations in for the 2nd vlookup which will convert to your abbreviation

=VLOOKUP(VLOOKUP(A5,sheet2!A:D,4,FALSE),AG:AH,2,FALSE)

This is perfect!! so simple lol

Thank you 100 times