This is exactly what I need to do also - I can get your formula below to
work, it does pull the value for code 1 with 3 users.

But is there a generic formula that would pull the value for any code 1 thru
3 matching to any # of users 1-10? I would like to put the code number in
one column and the the user # in another column and the formula to always
find the correct value as the code and user # change.


"Jacob Skaria" wrote:

Try the below which will retrive the value for code 1 with 3 users..assuming
the value is in Col C ..

=INDEX(C1:C100,MATCH(1,(A1:A100=3)*(B1:B100=1),0))

Please note that this is an array formula. Within the cell in edit mode (F2)
paste this formula and press Ctrl+Shift+Enter to apply this formula. If
successful in 'Formula Bar' you can notice the curly braces at both ends like
"{=<formula}"

If this post helps click Yes
---------------
Jacob Skaria


"GRK" wrote:

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