| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Table Lookup (VLookup, Index, Match)
Many Thanks Everyone. That did the trick.
"Tom Ogilvy" wrote: Yes, that was a typo in that I didn't thoroughly clean up what the OP presented. Thanks for the correction. -- Regards, Tom Ogilvy "Hari" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup / Index/Match | Excel Worksheet Functions | |||
| Index, Match, Lookup, Vlookup or Combination? | Excel Worksheet Functions | |||
| table, index, array, match, lookup? | Excel Worksheet Functions | |||
| Lookup/Index/Match HELP! | Excel Discussion (Misc queries) | |||
| MATCH, INDEX, LOOKUP - Help! | Excel Worksheet Functions | |||
Threaded Mode
