Posted to microsoft.public.excel.worksheet.functions
|
|
function =IFERROR LOOKUP works in excel 2007 not in excel 2003
Here's a VB module I used in excel 2003
Go to Tools - Macro -- Visual Basic Editor
Select insert - Module
Paste this:
Function IfError(formula As Variant, show As String)
On Error GoTo ErrorHandler
If IsError(formula) Then
IfError = show
Else
IfError = formula
End If
Exit Function
ErrorHandler:
Resume Next
End Function
Then File Close and return to excel
"David Ryan" wrote:
Hi Folks the function below works in excel 2007 but not in 2003.
=IFERROR(LOOKUP('HDU Roster'!$C$9,{7,8,11,1330,1430,2245},{8,8,8,8,8,8} ),0)
The file is saved in 97 - 2003 compatibility mode.
When the spreadsheet is opened in excel 2003 (it opens without problems) the
function gives "#name" error messages and the function is now,
=_xlfn.IFERROR(LOOKUP('HDU
Roster'!$C$9,{7,8,11,1330,1430,2245},{8,8,8,8,8,8} ),0)
The latest compatability pack is installed.
Any advice appreciated
|