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!