USERS CODE 1 MONTHLY CODE 2 3 PTMS CODE 3 ANNUAL
1 1 197 2 667 3 1597
2 1 167 2 557 3
1467
3 1 137 2 467 3 1197
4 1 117 2 407 3
1067
5 1 107 2 357 3
927
6 1 107 2 357 3
927
7 1 107 2 357 3
927
8 1 107 2 357 3
927
9 1 107 2 357 3
927
10 1 97 2 327 3
797

The above is a table of information which I wish to retrieve to sheet 2.
Sheet 2 looks like the following.
CUST CUSTOMER NUMBER SALES
DATE CODE PAY TYPE NAME OF USERS PRICE PER USER
6/16/09 1 MO JONES INC 3

I would like to retrieve the value for code 1 with 3 users, therefore, the
value should be 137. What would the SALES PRICE PER USER function or formula
be for any code 1-3 matched to number of users 1-10?

Thanks for any help with the above.

--
GRK