Put Value at Intersection

[monagan]

I have Name,Date,HoursWorked

I need to know how to have excel look in another excel file and find where Name(column A) and date (row 3) intersect, and place the hours worked there

 

[mbarron]

Is name,date,hrs a single comma seperated cell or three seperate cells?

When you want to put the hour there, as in,

and place the hours worked there

is the there the grid?


Mike

 

[mbarron]

Assuming the following:
1. The name, date, and hours are in different cells
2. You want to put the hours worked into the intersection in a grid

Here is my sample data:

name	date        hrs
mike	08/05/04	8
dave	08/05/04	10
jill	08/05/04	5
mike	08/06/04	8
dave	08/06/04	10
jill	08/06/04	5
mike	08/07/04	8
dave	08/07/04	10
jill	08/07/04	5
mike	08/08/04	8
dave	08/08/04	10

My table resulted in:

	       mike  dave  jill
8/5/2004	8	10	5
8/6/2004	8	10	5
8/7/2004	8	10	5

Using named ranges of Name, Date and Hours the formula I used was (in cell B2):

=SUMPRODUCT((name=B$1)*(date=$A2)*(hours))

You can copy this formula across and down to fill the table.

Mike

 

[monagan]

Mike

I was thinking of something more like with out a formula.
Where I can just click a submit button.

They way you assumed my data was correct.