| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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"}) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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"}) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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"}) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using the lookup function
Thanks alot man
|
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
using the lookup function
welcome
best wishes Sreedhar "Brian Kav" wrote: Thanks alot man |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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"}) |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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"}) |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to combine an IF Function with a lookup function to determine | Excel Worksheet Functions | |||
| LOOKUP FUNCTION | Excel Worksheet Functions | |||
| Help using lookup function | Excel Discussion (Misc queries) | |||
| Lookup function or something like it... | Excel Worksheet Functions | |||
| Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
Hybrid Mode
