| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Forumla Error
Can't seem to get this code to work correctly...
=VLOOKUP(Weekly Data'! COUNTIF(M2:M256,"W*") Any help would be appreciated. Rob |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Forumla Error
What are you trying to accomplish? Can't quite see where the VLOOKUP fits in
there. "Killer" wrote: Can't seem to get this code to work correctly... =VLOOKUP(Weekly Data'! COUNTIF(M2:M256,"W*") Any help would be appreciated. Rob |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Forumla Error
Trying add formula reading data from another page called "Weekly Data"
=COUNTIF(M2:M256,"W*") "tim m" wrote: What are you trying to accomplish? Can't quite see where the VLOOKUP fits in there. "Killer" wrote: Can't seem to get this code to work correctly... =VLOOKUP(Weekly Data'! COUNTIF(M2:M256,"W*") Any help would be appreciated. Rob |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Forumla Error
More information is needed. VLOOKUP requires at least two arguments, and the
role of COUNTIF(M2:M256,"W*") in this process is completely obscure. Describe in words what you are trying to do and how the data is layed out. Jerry "Killer" wrote: Trying add formula reading data from another page called "Weekly Data" =COUNTIF(M2:M256,"W*") "tim m" wrote: What are you trying to accomplish? Can't quite see where the VLOOKUP fits in there. "Killer" wrote: Can't seem to get this code to work correctly... =VLOOKUP(Weekly Data'! COUNTIF(M2:M256,"W*") Any help would be appreciated. Rob |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Forumla Error
You want the result from the formula that is in the page called weekly data?
or you want the formula in your current sheet but to look up the data in Weekly Data? Perhaps this is what you want? =COUNTIF(Weekly Data!A1:A5,"W*") "Killer" wrote: Trying add formula reading data from another page called "Weekly Data" =COUNTIF(M2:M256,"W*") "tim m" wrote: What are you trying to accomplish? Can't quite see where the VLOOKUP fits in there. "Killer" wrote: Can't seem to get this code to work correctly... =VLOOKUP(Weekly Data'! COUNTIF(M2:M256,"W*") Any help would be appreciated. Rob |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Forumla Error
Thanks guys I figured it out. The sheet name Weekly Data was conflicting with
the code I just removed the word Data and the code works correctly. Thanks again! "tim m" wrote: You want the result from the formula that is in the page called weekly data? or you want the formula in your current sheet but to look up the data in Weekly Data? Perhaps this is what you want? =COUNTIF(Weekly Data!A1:A5,"W*") "Killer" wrote: Trying add formula reading data from another page called "Weekly Data" =COUNTIF(M2:M256,"W*") "tim m" wrote: What are you trying to accomplish? Can't quite see where the VLOOKUP fits in there. "Killer" wrote: Can't seem to get this code to work correctly... =VLOOKUP(Weekly Data'! COUNTIF(M2:M256,"W*") Any help would be appreciated. Rob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom error bars not working | Charts and Charting in Excel | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Problem Opening an Excel File MSO9.DLL Error | Links and Linking in Excel | |||
| error "module not found" | Excel Discussion (Misc queries) | |||
| #REF error | Excel Worksheet Functions | |||
Hybrid Mode
