Hi,

I've assumed your table is in coilumns A,B,C,D & E.

Make a table like this

Baseball Football Soccer
Jones 2 2.5 3
Smith 2 2.2 2.5
White 0 0 0

At the intersect of Jones/Baseball put this formula
=SUMPRODUCT(($A$2:$A$7=$I2)*($D$2:$D$7=J$1)*($E$2: $E$7))
Drag down and then across to get the numbers above
Note my table is in columns
I,J,K & L
Mike


"JMG" wrote:

Basic output from 3rd party database is .xls in a format similar to:

Name OtherData OtherData EventName PointsEarned
Jones xxxxx xxxxx baseball 2.0
Jones xxxxx xxxxx football 2.5
Jones xxxxx xxxxx soccer 3.0
Smith xxxxx xxxxx baseball 1.0
Smith xxxxx xxxxx football 1.1
Smith xxxxx xxxxx soccer 1.5
White...and so on

My Goal:
Lookup by Name and EventName, and return PointsEarned.

BASEBALL FOOTBALL SOCCER

Jones 2.0 2.5 3.0
Smith 1.0 1.1 1.5
White...

I also totally lack understanding of PivotTables, and out of pure
stubbornness, am trying to avoid using them. ...probably to my own demise.

Thanks in advance.
--
JMG