It work for me. I can send you the sample workbook if you need.

"L. S. Martin" wrote in message
...
Thanks for the info. I don't understand the "1" after the MATCH, but tried
it anyway and several variations. I never could get it to work. I believe
the problem is that the information I'm looking up is on a different sheet
from the two lookup entries (though that's no problem when looking up just
one entry). Thanks for trying.
"kk" <kkchoh @ yahoo dot com wrote in message
...
I'm using the following array formula. You may want to try...

A1:A10 - Date
B1:B10 - User ID
C1:C10 - Information

In E1: Date to lookup
In F1: User ID to lookup

In G1
=INDEX($C$1:$C$10,MATCH(1,($A$1:$A$10=$E1)*($B$1:$ B$10=$F1),0))

Confirm it by hitting Ctrl + Shift + Enter

kk

"L. S. Martin" wrote in message
...
I need to perform a lookup based on information shown in 2 adjacent
columns
(Col. A = Date, Col. B = UserID). Say the column with the information is
in
column C. Have no problem looking up based on just Column A, using
VLOOKUP(look_upvalue, table_array,MATCH(lookup_value, lookup_array,
match_type), FALSE), but it stops on the first entry for the date. I need
to look up info. for a certain user ID on a given date. After looking in
Help, it looks like INDEX might work, but I don't know how to set it up.
Any help would be greatly appreciated.
Thanks,
LSM