Using IF, MID and Vlookup

[Shanej69]

I am using excel to help me track server information and I nee help with something.
We are going to start using a new naming standard and I use the If and Mid and VLOOKUP statements not to look for a certain character in a cell to see if a system is production or non-production. The new naming standard will cause the character to be in 2 possible places.
Example
Old standard = PBPVAP1002
New standard = PZABPVAP1002

So I need to be able to account for both standards.
So what I need is if the second character is a Z then count over to the 5th character (P) and run a vlookup. If the second character is not a Z then use the old statement. The old or original statement is below.

=IFERROR(VLOOKUP(MID(A13527,3,1),'Ref Tables for Pivots'!G:H,2,FALSE),"Unknown")

Thank you in advance

 

[steve the fish]

Try this:

=IFERROR(VLOOKUP(MID(A13527,IF(MID(A13527,2,1)="z",5,3),1),'Ref Tables for Pivots'!G:H,2,FALSE),"Unknown")

 

[Shanej69]

That worked perfectly thank you very much.