using the lookup function
 

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

using the lookup function
 

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

"Brian Kav" wrote:

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

using the lookup function
 

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

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

"Brian Kav" wrote:

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

using the lookup function
 

Thanks alot man

using the lookup function
 

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

using the lookup function
 

welcome
best wishes
Sreedhar

"Brian Kav" wrote:

Thanks alot man

using the lookup function
 

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

"David Biddulph" wrote:

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

using the lookup function
 

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

Pete

On Oct 2, 2:33*pm, Steve Salzman <Steve
wrote:
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