Match or Lookup

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

Guest

Hi,

Basically from a years worth of sales data I want to identify what value of
business was written by a Sales Area in 3 week of 2006 - what formulas do I
need to look at? Note: I don't need to sum week 3 as the total value is
already given.

The week no. and Sales Area are the key identifiers here.

am a novice so simpleton terms are appreciated.
 
Hi Andy

Create a new query based on the table(s) which contain the week number and
Sales Area infomation.

In the query column (containing week number and sales area) click on the
Criteria row.
You can either prompt the user to insert the information like this
[Please enter week number]
[Please enter sales area]

Or - if you only want a specific set of results, you can simply enter the
week number into the criteria row directly and also the sale area number

Hope this helps
 
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

Not sure how to make this work 3
match two conditions to return value from pivot table 1
Finding the date of the first day of the week using "ww" to ID Wee 3
I'm stumped 1
Calc Sales based on Stock Count 3
A Challenge: Summary and Append Queries 2
access or excel 2
Steam user spends $13,000 to get to Steam's highest level 2

Back
Top