Hello there,
I'm currently using Excel 2010, but I have a spreadsheet that's not working for those using Excel 2003 due to some functions that are too new for it.
In particular I'm trying to figure out a way to make this work:
=IF(ISBLANK(F6),"",IFERROR(VLOOKUP(F6,'Master Data'!A:B,2,FALSE),"Not Available."))
I've done some googling and IFERROR seems to be the problem. Apparently there is an ISERROR formula that is compatible with 2003, but I've been unable to make it work.
Bookmarks