hey im using the following code and days and mids are are showing up as #N/A
thanks for any help you can give me


=LOOKUP(Sheet2!AB6,{"PD","S","M","D","X","L","SM", "W","AR","R"},{"Platoon
Duty","Swings","Mids","Days","Off","Leave","SSRP Mids","War Fighter","Arms
Room","Range"})