As in so many cases, the answer is in the Excel Help for the function you
are trying to use. Look at the paragraph headed "Important".
--
David Biddulph

"Brian Kav" <Brian wrote in message
...
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"})