Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba code for lookup worksheet function
hello,
Any help is welcome. I would like to write a vba code for looking up for a particular cell value from a range of cells matching any one row & column, similar to Combine the Index and Match formulas in Microsoft Excel. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba code for lookup worksheet function
you can use index and match in VBA,
Application.Index(Range("A1:Z26"), _ Application.Match(rowval,Range("A1:A26,0), _ Application.Match(colVal, Range("A1:Z1"),0)) -- Regards, Tom Ogilvy Binoy wrote in message ... hello, Any help is welcome. I would like to write a vba code for looking up for a particular cell value from a range of cells matching any one row & column, similar to Combine the Index and Match formulas in Microsoft Excel. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LOOKUP FUNCTION? (LOOKUP VALUE BEING A TIME RENERATED FROM A FORMU | Excel Discussion (Misc queries) | |||
LOOKUP worksheet function | Excel Discussion (Misc queries) | |||
Worksheet Rank / Lookup function | Excel Worksheet Functions | |||
Zip Code Lookup Add-in | Excel Discussion (Misc queries) | |||
What is the VBA equivilate to Excel worksheet function lookup | Excel Programming |