Forumla Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can't seem to get this code to work correctly...

=VLOOKUP(Weekly Data'! COUNTIF(M2:M256,"W*")

Any help would be appreciated.

Rob
 
What are you trying to accomplish? Can't quite see where the VLOOKUP fits in
there.
 
What are you trying to accomplish? Can't quite see where the VLOOKUP fits in
there.
 
Trying add formula reading data from another page called "Weekly Data"

=COUNTIF(M2:M256,"W*")
 
Trying add formula reading data from another page called "Weekly Data"

=COUNTIF(M2:M256,"W*")
 
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
 
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
 
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*")
 
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*")
 
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!
 
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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use tab name in Vlook Up 5
SUMIF problem 1
Help with the forumla, whether it works with IF condition or Vlook 3
How to count with values from multiple columns? 5
Search for data and return cell reference 3
Formula results don't change when it's pasted/dragged into a new c 2
Need a forumla help 3
Syntax to Nest ISERROR with a VLookup 2

Back
Top