Yes I will take a look at it if you still need it....sorry I haven't
responded to this in a while...send me a PM if you can...if not, just
post back and I'll give you my e-mail
LM Wrote:
Malik,
Thanks for the information. I'm afraid I still can't get it or any of
the other suggestions to work. I'm running Excel 2000 and trying
create a
worksheet that will get information from several other tabs in the
same
workbook. Each Tab has been sorted and has the dates in Column A and
the
users in Column B. On this worksheet I am entering the date in Cell A3
(merged a,b,c) and the User in Cell D3, then in other cells I am
entering
the Index/Match formulas to look up say the Hi Temp in Column G of the
Tab
named DWRs. I will send an abbreviated copy of the workbook if anyone
is
willing to take a look at it.
Thanks also to KK for offering a copy of his workbook.
"malik641" wrote
in
message ...

This works:

E1=Date
F1=UserID


{=INDEX($C$1:$C$10,MATCH($E$1,$A$1:$A$10,0),MATCH( $F$1,$B$1:$B$10,0))}

Array function, so press Ctrl+Shft+Enter

L. S. Martin Wrote:
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


--
malik641


------------------------------------------------------------------------
malik641's Profile:
http://www.excelforum.com/member.php...o&userid=24190
View this thread:
http://www.excelforum.com/showthread...hreadid=384559



--
malik641
------------------------------------------------------------------------
malik641's Profile: http://www.excelforum.com/member.php...o&userid=24190
View this thread: http://www.excelforum.com/showthread...hreadid=384559