using the lookup function

[Brian Kav]

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"})

 

[Brian Kav]

Arms room and war fighter and leave also show up as #N/A i dont know about
ssrp and range

 

[yshridhar]

Modify it to
=LOOKUP(Sheet2!AB6,{"AR","D","L","M","PD","R","S","SM","W","X"},{"ArmsRoom","Days","Leave","Mids","PlatoonDuty","Range","Swings","SSRP
Mids","War Fighter","Off"})
Best wishes
Sreedhar

 

[Brian Kav]

Thanks alot man

 

[David Biddulph]

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".

 

[yshridhar]

welcome
best wishes
Sreedhar

 

[Steve Salzman]

Dave,

I'm trying to use a lookup function to return some data. Unfortunately, the
data being looked up can occur in 1 to 5 character long. how do this lookup
without doing a find and replace on the first "-" (which is where i want to
stop my lookup) with 5 to 10 spaces? Then doing the lookup that way...
There's got to be a better way

 

[Pete_UK]

Can you post some examples of what you have and what you are trying
to do?

Pete