Thread: Forumla Error
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jerry W. Lewis Jerry W. Lewis is offline
external usenet poster
 
Posts: 837
Default 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