Solved: Index Match using named ranges

[JarryS88]

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
[VBA]x = Application.Index(SSI, 1, Application.Match(RngAC, MatchKey, 0))[/VBA]

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

[JarryS88]

Oh, i should also mention that MatchKey and SSI are on a seperate workbook. thats why im working with names so it doesnt need the workbook specified.

please correct me if i'm wrong.

[JarryS88]

dont worry, i realised that i had the match in column instead of row.

all good now

[JarryS88]

back again.

new issue. sorry

ok so ive used a formula feed into vba of an index match however i want the index to be offset(-1,0) yet as its a formula and not a value i dont know how.