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:
<TBODY>
</TBODY>
Thank you
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:
Action Required</SPAN> | AR</SPAN> |
Pending</SPAN> | PN</SPAN> |
Scheduled PE</SPAN> | SE</SPAN> |
PE Completed</SPAN> | PC</SPAN> |
Test Scheduled</SPAN> | T</SPAN> |
<TBODY>
</TBODY>
Thank you
Last edited: