Thread: function =IFERROR LOOKUP works in excel 2007 not in excel 2003
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Ryan David Ryan is offline
external usenet poster
  
Posts: 27
Default function =IFERROR LOOKUP works in excel 2007 not in excel 2003
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


Reply With QuoteReply With Quote