=INDEX(L1:L100,MATCH(40066&80964,K1:K100&Q1:Q100,0 ))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Billing Goddess" wrote in
message ...
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