apply formula to each cell in range - relative references

[BuZZarD73]

I've managed to do what I set out to, which is to put a relative formula in each of the cells in a range in a table using the following section of code:

Please Login or Register  to view this content.

However, as some of the cell values being returned are blank, I get #N/A returned.

If I change to the following

Please Login or Register  to view this content.

the formulas stop being put in any of the cells in the range.

Putting the iferror formula into each cell manually works though.

Anybody know why cos it's killing me

[BuZZarD73]

I've had to change the formula as Index Match Match wouldn't work as there's more than one instance of the look up so used Sumproduct.

Please Login or Register  to view this content.

This returns zeros where no corresponding entry is found so works ok with the rest of the math, however I'm still confused as to why it stops doing anything with IFERROR.

[JOHN H. DAVIS]

Maybe add an if statement?

Please Login or Register  to view this content.

[BuZZarD73]

Yup, that does the trick.

I suppose I could remove the iferror part of the formula (as it's ignored) and just use your line to hide the inevitable error.

Another 'quirk' to add to the list.

Cheers.

[JOHN H. DAVIS]

Glad to hear it works for you.