looking up 2 values
 

I have a colum of dates and a colum of websites. What I am trying to do is
lookup
the date and if the date matches. It would then lookup the the webiste and
return the of times it sees the matching date and website to a seperate sheet
under that date:

10/15/07 10/16/07
Monster 4 0
Careerbuilder 6 3

The above is what is what I am trying to.

looking up 2 values
 

Try something like this:

sites = range of websites
dates = range of dates

=SUMPRODUCT(--(sites=$A2),--(dates=B$1))

Copy across then down

--
Biff
Microsoft Excel MVP


"tim2216" wrote in message
...
I have a colum of dates and a colum of websites. What I am trying to do is
lookup
the date and if the date matches. It would then lookup the the webiste and
return the of times it sees the matching date and website to a seperate
sheet
under that date:

10/15/07 10/16/07
Monster 4 0
Careerbuilder 6 3

The above is what is what I am trying to.

looking up 2 values
 

Try this:
In A1:A10 enter some names (websites)
In B1:H1 enter some dates
In B2:H10 enter some numbers
In K1 enter the name of one of your websites and in J1 enter a data that you
know to be present in B1:B10
In L1 enter this formula
=VLOOKUP(K1,A2:H10,MATCH(J1,B1:H1,0)+1,FALSE)
The MATCH locates the relative position of the date. We add one since our
data base begins in A not B. The Vlookup finds the website name and returns
the number from the correct column
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"tim2216" wrote in message
...
I have a colum of dates and a colum of websites. What I am trying to do is
lookup
the date and if the date matches. It would then lookup the the webiste and
return the of times it sees the matching date and website to a seperate
sheet
under that date:

10/15/07 10/16/07
Monster 4 0
Careerbuilder 6 3

The above is what is what I am trying to.

looking up 2 values
 

Decided to do this in colums because of how the data is coming into the page.
So column a is where the dates will be and column b is where the website name
will be listed. Here is the conde I am using, I am getting a #ref error.

=VLOOKUP(S7,A4:A1000,MATCH(T3,B4:B1000,0)+1,FALSE)

s7 is the date that I am looking for and t3 is the name of the website I am
looking for. Any ideas?

"Bernard Liengme" wrote:

Try this:
In A1:A10 enter some names (websites)
In B1:H1 enter some dates
In B2:H10 enter some numbers
In K1 enter the name of one of your websites and in J1 enter a data that you
know to be present in B1:B10
In L1 enter this formula
=VLOOKUP(K1,A2:H10,MATCH(J1,B1:H1,0)+1,FALSE)
The MATCH locates the relative position of the date. We add one since our
data base begins in A not B. The Vlookup finds the website name and returns
the number from the correct column
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"tim2216" wrote in message
...
I have a colum of dates and a colum of websites. What I am trying to do is
lookup
the date and if the date matches. It would then lookup the the webiste and
return the of times it sees the matching date and website to a seperate
sheet
under that date:

10/15/07 10/16/07
Monster 4 0
Careerbuilder 6 3

The above is what is what I am trying to.

looking up 2 values
 

In your original post you had website names in a column and dates in a row
along the top. This would allow a 2D lookup.
Now you are using A1:A100 for dates and B1:B100 for dates - not two
dimensional. Do you really have websites names in A and dates in B?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"tim2216" wrote in message
...
Decided to do this in colums because of how the data is coming into the
page.
So column a is where the dates will be and column b is where the website
name
will be listed. Here is the conde I am using, I am getting a #ref error.

=VLOOKUP(S7,A4:A1000,MATCH(T3,B4:B1000,0)+1,FALSE)

s7 is the date that I am looking for and t3 is the name of the website I
am
looking for. Any ideas?

"Bernard Liengme" wrote:

Try this:
In A1:A10 enter some names (websites)
In B1:H1 enter some dates
In B2:H10 enter some numbers
In K1 enter the name of one of your websites and in J1 enter a data that
you
know to be present in B1:B10
In L1 enter this formula
=VLOOKUP(K1,A2:H10,MATCH(J1,B1:H1,0)+1,FALSE)
The MATCH locates the relative position of the date. We add one since our
data base begins in A not B. The Vlookup finds the website name and
returns
the number from the correct column
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"tim2216" wrote in message
...
I have a colum of dates and a colum of websites. What I am trying to do
is
lookup
the date and if the date matches. It would then lookup the the webiste
and
return the of times it sees the matching date and website to a seperate
sheet
under that date:

10/15/07 10/16/07
Monster 4 0
Careerbuilder 6 3

The above is what is what I am trying to.