R
Rachael F
Hello
I have a lookup formula in D10 that looks up to range D75
86 & displays the
most recently entered (percent) value in the range:
=IF(ISNA(LOOKUP(2,1/D7586,D7586)),"",LOOKUP(2,1/D7586,D7586))
This formula displays the correct value.
When I copy this formula to cells E10:H10, amending the range as required,
#N/A is displayed. There are curently values in cells E75:E77 but not in
E78:E86. (This is the same as D7586.)
Don't know if this is relevant but cells D75:E86 all contain the same array
formula, eg =IF(ISERROR('November 2007'!H9),0,'November 2007'!H9)
Does anyone know why this is happening please? All helps gratefully received.
Best wishes.
Rachael
I have a lookup formula in D10 that looks up to range D75
86 & displays themost recently entered (percent) value in the range:
=IF(ISNA(LOOKUP(2,1/D75
86,D7586)),"",LOOKUP(2,1/D7586,D7586))This formula displays the correct value.
When I copy this formula to cells E10:H10, amending the range as required,
#N/A is displayed. There are curently values in cells E75:E77 but not in
E78:E86. (This is the same as D75
86.)Don't know if this is relevant but cells D75:E86 all contain the same array
formula, eg =IF(ISERROR('November 2007'!H9),0,'November 2007'!H9)
Does anyone know why this is happening please? All helps gratefully received.
Best wishes.
Rachael