using the lookup function

  • Thread starter Thread starter Brian Kav
  • Start date Start date
B

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"})
 
Arms room and war fighter and leave also show up as #N/A i dont know about
ssrp and range
 
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
 
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".
 
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
 
Back
Top