JarryS88
10-19-2010, 07:28 PM
Hi,
i have a vba code where i want to take the result of a match and get the result of that row number in an array (index).
it is written as follows
x = Application.Index(SSI, 1, Application.Match(RngAC, MatchKey, 0))
SSI being the named range in which i want to get the value
RngAC being the named range (single cell, changes with loop) that i want to find
and
MatchKey being the range in which i want to find RngAC.
my result is giving #value. when i know it should come up with a result
have i typed the code wrong?
any help is appreciated
i have a vba code where i want to take the result of a match and get the result of that row number in an array (index).
it is written as follows
x = Application.Index(SSI, 1, Application.Match(RngAC, MatchKey, 0))
SSI being the named range in which i want to get the value
RngAC being the named range (single cell, changes with loop) that i want to find
and
MatchKey being the range in which i want to find RngAC.
my result is giving #value. when i know it should come up with a result
have i typed the code wrong?
any help is appreciated