Lookup Help

[arjcvg]

Hi Guys!

I need help again... I don't really know how to explain it by words s
I'll be explaining what I need by examples... Hope you'll get what
mean...


For example I have the following data in Sheet2

DATE - NAME - SALES
8/1 - Paul - 10
8/1 - Gina - 23
8/1 - Lester - 65
8/1 - June - 12
8/1 - Lex - 8
8/2 - Paul - 6
8/2 - Gina - 1
8/2 - Ester - 4
8/3 - Paul - 8
8/3 - Gina - 5

How can I create a report in another sheet that something looks lik
this:

-----------------------------------------------------------|
NAME----------- |--- 8/1---- |--- 8/2----|--- 8/3----|
-----------------------------------------------------------|
Paul-------------|----10------|----6-------|----8------|
-----------------------------------------------------------
Gina-------------|-----23-----|-----1------|-----5-----|
-----------------------------------------------------------
so on and so forth...

Do you know how to do this without using Pivot?

I also attached here a sample of data... I have two sheets there.. th
Raw and Summary

Thanks for all the help!


Ar

Attachment filename: sample.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=64731

 

[Frank Kabel]

Hi
if you have your dates and names filled on sheet 2 put the following
formula in B2:
=SUMPRODUCT(--('sheet1'!$A$1:$A$1000=B$2),--('sheet1'!$B$1:$B$1000=$A2)
,'sheet1'!$C$1:$C$1000)

and copy across

 

[arjcvg]

If it is not too much to ask... Can you do it on the sample file that I
attached on my original post. Coz I tried doing it but i'm having a
hard time getting the right formula.. Thanks!

 

[Frank Kabel]

Hi
sorry, no I won't open attachments. If you have problems
applying these formulas try the following:
- post some more infos about the layout of your report
sheet (as said I assumed you have inserted the dates and
names manually)
- post the formula you've tried and which did not work
- describe exactly what went wrong

 

[arjcvg]

Oh it's okay... I got it already... Thanks for all the help! You're ver
helpful! Thanks so much