If the Col_L values will always be numeric
AND there will only be ONE Col_L value for
any combination of Col_K and Col_Q,
then try this:

A1: 40066
A2: 80964

B1: =SUMPRODUCT((K1:K10=A1)*(Q1:Q10=A2)*L1:L10)
In this case the formula returns 5.

Change range references to suit your situation.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Billing Goddess" wrote:

I hope someone can help!

I have the following data

col K col L col Q

40066 $2000.00 80962
40066 $10,000.00 80963
40066 $5.00 80964
40067 $75.00 80966
40067 $20.00 80900
40068 $2200.00 80901

I need the value in col L if col k is 40066 and col q is 80964. All values
are always within one row, meaning that if 40066 and 80964 are found, the $$
will be in that row also. Does this make sense??

--
Many Thanks,
Paula