B

#### BabyMc

Is there a method of using a wildcard function within edit/replace (in Excel

2003) so that I can tweak the way a formula works?

The example I have is the following formula

=IF(ISERROR(VLOOKUP($A8,DataImport!$A:$J,5,FALSE)),"",VLOOKUP($A8,DataImport!$A:$J,5,FALSE))

which I would like to change to

=IF(ISERROR(VLOOKUP(TEXT($C8,"0000),DataImport!$D:$E,2,FALSE)),"",VLOOKUP(TEXT($C8,"0000"),DataImport!$D:$E,2,FALSE))

The issue is (I think) that this formula is repeated many times over in one

column over a number of worksheets - therefore I should like the row below to

be amended from $A9 to $C9 and so on.

I can't see how to do this as I need to change the formula either side of

the cell reference and therefore doing this in 2 parts, which at first I

thought I could, would mean the formula not working in the interim (and

therefore edit/replace not working).

I also tried to use a wildcard in place of the row reference but this didn't

seem to work either.

Any help is appreciated.

Thanks