Hi,
One of mine friend has send me 2007 excel file and I am using Excel 2003, some fields are showing =_xlfn.IFERROR(VLOOKUP( this error, how it can be resolved. Same for =+_xlfn.SUMIFS(..
--
Thanks & Regards,
Mannu
Hi,
One of mine friend has send me 2007 excel file and I am using Excel 2003, some fields are showing =_xlfn.IFERROR(VLOOKUP( this error, how it can be resolved. Same for =+_xlfn.SUMIFS(..
--
Thanks & Regards,
Mannu
Both Iferror and Sumifs were not available back in Excel 2003. The only option is to use functions that are compatible with XL03.
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
SUMIFS, DOES NOT WORK IN eXCEL 2003. yOU HAVE TO USE sumproduct for this.
IF(ISERROR(Your formula),"",your formula, is the way to replace the IFERROR
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks