Hi,

You could use:

=SUMPRODUCT(--(A$2:A$4=J1),--(B$1:D$1=K1),B$2:D$4)

Where J1 contains the Title and K1 contains the Product. Copy the formula
down as far as necessary.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Rod" wrote in message
...
I have a table:

Title Prod1 Prod2 Prod3
Rep $1 $2 $3
SRep $4 $5 $6
Mgr $7 $8 $9

If SRep sells Prod3 I want to be able to cross reference and return $6.
The table for me to search is static. The information that will change
is
the salesperson's title & what product. How can I traverse this matrix
other
than VLookup?

Thanks Much!