Help with formula and index/match on seperate sheet

[heathbo]

Hi all

Please look at this and tell me obvious thing I am missing please

Please Login or Register  to view this content.

MKM = Named range
Lyssa = sheet name data is on

Just cannot see it. Thanks

edit
This works
[CODE][/Range("j3:j" & lastrow).Formula = "=IF(ISNUMBER(MATCH(I3,""mkm"",0)),"""",IFERROR(INDEX(LYSSA!$D$1:$G$200,MATCH(A3,LYSSA!$G$1:$G$200,0),1),""""))"CODE]

This also doesn't
[CODE][/Range("j3:j" & lastrow).Formula = "=IF(ISNUMBER(MATCH(I3,""mkm"",0)),"""",IFERROR(INDEX(LYSSA!D:G,MATCH(A3,LYSSA!G:G,0),1),""""))"CODE]



Trting to get out of fixed ranges, understand using offset named range does not work with index/match

[Fluff13]

Is Lyssa the actual name of the sheet, or a variable?

[heathbo]

Lyssa is a sheet name

[Fluff13]

Ok, how about

Please Login or Register  to view this content.

[heathbo]

Thanks Fluff13
Can you explain why this works please

Ok, how about

Please Login or Register  to view this content.

[Fluff13]

Because that's the correct way to write the formula.

Using ""MKM"" makes it a string value & not a range & the way you did the sheet name assumes that LYSSA is a variable.