Assuming your table is located in A1:D4 exactly as shown...

=SUMPRODUCT((A$2:A$4="Srep")*(B$1:D$1="Prod1")*B$2 :D$4)

where you can use a cell reference for the "Srep" and "Prod1" (you didn't
tell us the layout of your data that references this table). You will have
to preface the above ranges with the Sheet name the table is locate on if
your will be putting the above formula on a different worksheet. The above
formula can be copied down or across as long at the cell references you use
for "Srep" and "Prod1" use relative addressing.

--
Rick (MVP - Excel)


"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!