I have a similar problem, but I can't seem to get it to work. Could it be
because I'm on Excel 2000?

My table is something like
Jan Feb Mar
Jones 1 2 3
Smith 4 5 6
Murphy 7 8 9
My statement is:
intMonthlyInitiativeHours = Index(A1:D4, Match("Smith", A1:D4, 0),
Match("Feb", A1:D4, 0))
I get
Compile Error: Expected: list seperator or )
and it points to the first colon.
Can you please help? Many Thanks.
"Fable " wrote:

I developed a formula to do such a search with multi criteria, the code
is below for you to study. Hopefully this helps and gets you closer to
what you want. (note this formula is consumes a bit recalculating time
when copied over & over)

=IF(ISNA(INDEX(sheet1!$B:$B,MATCH(CONCATENATE($B13 8,C$136),sheet1!$A:$A,0)))=TRUE,0,INDEX(sheet1!$B: $B,MATCH(CONCATENATE($B138,C$136),sheet1!$A:$A,0)) )


-Fable


---
Message posted from http://www.ExcelForum.com/