Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
That is, one that is not taken from the spreadsheet.
Before I start banging my head against the wall, I thought I would ask the experts! Something like: Sub MySub Dim HLookupArray as Variant Dim n,m as Long n = Something m = SomethingElse LookupVal = SomethingElseYet HLookupArray = Array(n,m) (In hear put code assigning values to the array nodes) SlowWalker = Application.HLookup(LookupVal, HLookupArray, 4, False) End Sub Thank You, -plh |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
hlookup in array | Excel Discussion (Misc queries) | |||
HLOOKUP: specify table array in a cell | New Users to Excel | |||
array formula with if and hlookup | Excel Worksheet Functions | |||
HLookup? or an array function?? | Excel Worksheet Functions | |||
How do I find a value in an array (VLOOKUP? HLOOKUP?) | New Users to Excel |