Thanks - sounds like EXACTLY what I was looking for!
"Andy Wiggins" wrote in message
...
This file might be a help:
http://www.bygsoftware.com/examples/...s/vlookup2.zip
It's in the "Worksheet" section on page:
http://www.bygsoftware.com/examples/examples.htm

Look up on two fields with this alternative to VLOOKUP


--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-


"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