View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Hari[_3_] Hari[_3_] is offline
external usenet poster
 
Posts: 157
Default Table Lookup (VLookup, Index, Match)

Hi Tom,

Havent used match,index etc in VB... But

In the column argument for match you have indicated
"Application.Match("Feb", Range("A1:D4"), 0))" where the range is not a 1D
array?

Shouldnt it be "Application.Match("Feb", Range("A1:D1"), 0))"

Please correct me if am wrong.

Regards,
Hari
India

"Tom Ogilvy" wrote in message
...
intMonthlyInitiativeHours = Application.Index(Range("A1:D4"), _
Application.Match("Smith", Range("A1:A4"), 0), _
Application.Match("Feb", Range("A1:D4"), 0))

--
Regards,
Tom Ogilvy


"Budget Programmer" wrote in
message ...
I have a Table Lookup 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.

--
Programmer on Budget