Get a text in for specific day sumproduct / dget
 

Hello
I have a large worksheet with contact details and booking areas (Booking 1,
Booking 2 etc.):

Booking 1
Booking 2
Title Forename Name Area From To Area From
To
Mr Alex Smith Blue 5/1/08 8/7/08 Orange
4/1/08 2/10/09
Ms Vicki Life Orange 8/1/08 15/7/08 Blue
10/1/08 20/10/08

In another excel file (or in another worksheet) i would like to see the name
of the person who has the same entry date and area. See example:

Date Blue Orange
1/01/08
2/01/08
3/01/08
4/01/08 Mr Alex Smith
5/01/08 Mr Alex Smith
6/01/08
7/01/08
8/01/08 Ms Vicki Life
9/01/08
10/01/08 Ms Vicki Life
etc.

I tried it with DGET (it's not the best solution because i have to create a
massive worksheet) What about SUMPRODUCT?
Thanks for your help.

Get a text in for specific day sumproduct / dget
 

to get the column use match

=MATCH("orange",$1:$1)

You can put the match in a vlookup

=VLOOKUP(Date,A2:C10,MATCH("orange",$1:$1))

"Hud67" wrote:

Hello
I have a large worksheet with contact details and booking areas (Booking 1,
Booking 2 etc.):

Booking 1
Booking 2
Title Forename Name Area From To Area From
To
Mr Alex Smith Blue 5/1/08 8/7/08 Orange
4/1/08 2/10/09
Ms Vicki Life Orange 8/1/08 15/7/08 Blue
10/1/08 20/10/08

In another excel file (or in another worksheet) i would like to see the name
of the person who has the same entry date and area. See example:

Date Blue Orange
1/01/08
2/01/08
3/01/08
4/01/08 Mr Alex Smith
5/01/08 Mr Alex Smith
6/01/08
7/01/08
8/01/08 Ms Vicki Life
9/01/08
10/01/08 Ms Vicki Life
etc.

I tried it with DGET (it's not the best solution because i have to create a
massive worksheet) What about SUMPRODUCT?
Thanks for your help.