Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#N/A displayed when Lookup Formula is copied
Hello
I have a lookup formula in D10 that looks up to range D75:D86 & displays the most recently entered (percent) value in the range: =IF(ISNA(LOOKUP(2,1/D75:D86,D75:D86)),"",LOOKUP(2,1/D75:D86,D75:D86)) 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:D86.) 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula is displayed instead of the result | Excel Discussion (Misc queries) | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
Cell Displayed Does Not Equal Cell Copied | Excel Worksheet Functions | |||
CountIf formula results in the formula itself being displayed. | Excel Worksheet Functions | |||
formula is displayed as literal text instead of formula result | Excel Discussion (Misc queries) |