Lookup Help
 

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
--
Message posted from http://www.ExcelForum.com

Lookup Help
 

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


--
Regards
Frank Kabel
Frankfurt, Germany


Hi Guys!

I need help again... I don't really know how to explain it by words
so
I'll be explaining what I need by examples... Hope you'll get what I
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 like
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..
the
Raw and Summary

Thanks for all the help!


Arj

Attachment filename: sample.xls
Download attachment:
http://www.excelforum.com/attachment.php?postid=647311 ---
Message posted from http://www.ExcelForum.com/

Lookup Help
 

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!


---
Message posted from http://www.ExcelForum.com/

Lookup Help
 

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

-----Original Message-----
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!


---
Message posted from http://www.ExcelForum.com/

.

Lookup Help
 

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

--
Message posted from http://www.ExcelForum.com