Expand With Range Formula

[timbo1957]

Hi,

I have this piece of code which works perfectly -

Please Login or Register  to view this content.

I need to amend the vlookup part to include an if(isna - I have tried this as shown below but it doesn't work, I know it's to do with the positioning of the " but I can't seem to get it right.

Please Login or Register  to view this content.

If I were writing the formula normally it would look like this -

=IF(ISNA(VLOOKUP(H4,'Amazon Stock Report'!$AH$2:$AK$14451,4,FALSE)),0,VLOOKUP(H4,'Amazon Stock Report'!$AH$2:$AK$14451,4,FALSE))


Thanks for any help given.

[Norie]

Try removing the " between )).

[ragulduy]

.formula = "=IF(ISNA(VLOOKUP(H4,'Amazon Stock Report'!$AH$2:$AK$" & Lr1 & ",4,FALSE)),0,VLOOKUP(H4,'Amazon Stock Report'!$AH$2:$AK$" & Lr1 & ",4,FALSE))"

[timbo1957]

Thanks yudlugar, just what I needed.