Why is my Simple Recorded Macro not working?

Hi everyone,

I have recorded a macro to input a formula and drag down to get results for a whole table. Really simple.

This is what I wrote:

Please Login or Register  to view this content.

When I run this macro, why does nothing occur on the screen? viz a viz, no formulas appear where they are intended to be.

See attached workbook: To see what I'm on about, on open sheet, run macro "NotWorking"

Any help would be greatly appreciated!

Andrew

Please Login or Register  to view this content.

Just put in the Range you'd like to fill down from. Above I just assumed it was Range("F1")

Hi Andrew

You have errors with your formula as well.
You are indexing J4:47, whereas it should be J3:J46 and you are testing for hte 13 left characters of A4 in the first instance instead of A5

You formula should be
=IF(ISERROR(INDEX($L$3:$L$46,MATCH(LEFT(A5,13),$J$3:$J$46,0))),"",INDEX($L$3:$L$46,MATCH(LEFT(A5,13),$J$3:$J$46,0)))

or in R1C! notation
"=IF(ISERROR(INDEX(R3C12:R46C12,MATCH(LEFT(RC[-5],13),R3C10:R46C10,0))),"""",INDEX(R3C12:R46C12,MATCH(LEFT(RC[-5],13),R3C10:R46C10,0)))"

The code to achieve what you want would be better written as

Please Login or Register  to view this content.

The formula itself would be far more efficient if you used Countif to test for the presence of your code, rather than using ISERROR and 2 MATCH, INDEX functions

=IF(COUNTIF(R[-2]C[4]:R[41]C[4],LEFT(RC[-5],13)),INDEX(R3C12:R46C12,MATCH(LEFT(RC[-5],13),R3C10:R46C10,0)),"""")